Memoria DB uses native PostgreSQL methods for use authentication. For DB there are several ways to see “who is who”:
- trust – user is not verified. This method must be restricted for obvious security reasons. That’s why the installer configures server to be accessible with trust method only from the 127.0.0.1 address.
- ident – user authenticates in DB with the current system account, no password required. This method is used for initial PostgreSQL configuration in Unix-based systems.
- md5 – user inputs the username and MD5 hash of the password. This is the basic method for remote connections to the server, this method should be used for all user connections to Memoria.
The ident and trust authentication methods restricted for 127.0.0.1 or local unix-sockets are recommended for saving backups and other administrative purposes.