I noticed a difference in postgresql configuration between recent versions and much older versions (e.g. v0.4.2). The previous configuration would be more compatible with other applications on the same machine using a different database within the same postgresql-cluster, I guess? Was there a good reason for changing this?
"local openrem_db openrem_user md5" vs "local all all md5"
The default security settings are too restrictive to allow access to the database. • sudo nano /etc/postgresql/9.1/main/pg_hba.conf • Add the following line: – local openrem_db openrem_user md5 • sudo /etc/init.d/postgresql restart
The default security settings are too restrictive to allow access to the database. Assumes version 9.4, change as appropriate. sudo nano /etc/postgresql/9.4/main/pg_hba.conf Scroll down to the bottom of the file and edit the following line from peer to md5: local all all md5 Don’t worry about any lines that start with a # as they are ignored. If you can’t access the database when everything else is configured, you might need to revisit this file and see if there are other lines with a method of peer that need to be md5 Restart PostgreSQL so the new settings take effect: sudo service postgresql restart