FATAL: Peer authentication failed for user "postgres"
When we are getting error like
When we get error at the time of import the postgres database :-
: FATAL: Peer authentication failed for user "postgres"
then:-
Should be
local all postgres md5
The problem is still your pg_hba.conf file (/etc/postgresql/9.1/main/pg_hba.conf). This line:
local all postgres peerShould be
local all postgres md5
After altering this file, don't forget to restart your PostgreSQL server. If you're on Linux, that would be
sudo service postgresql restart
SEE ALSO,
http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge
sudo service postgresql restart
SEE ALSO,
http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge
Comments