29 novembre 2019
Robert Nasarek, « First Steps in Postgres », OoO, ID : 10670/1.erwgk2
By default, postgres allow only local connections and and uses peer authentification to access the databases. In some cases this provoke the error message " FATAL: Peer authentication failed for user "postgres" This is an explanation how to configure postgres to ask for encrypted password and allow remote connections. Change password for rootuser "postgres" Connect to the default database with user postgres sudo -u postgres psql template1 Set the password for user postgres ALTER USE...