aalvesjr · April 13, 2015 22:17
diff --git a/gistfile1.txt b/gistfile1.txt
 $ psql -U <qualquer usuario> -c "SELECT NOW()"
 psql: FATAL:  Peer authentication failed for user "<qualquer usuario>"

 se ocorreu mesmo após executar:
 $ sudo sed -i -E 's/host\s*all\s*all\s*127.0.0.1\/32\s*peer/host all all 127.0.0.1\/32 md5/' /etc/postgresql/9.4/main/pg_hba.conf

 subistituir todos os "peer" por "md5"
 $ sudo sed -i -E 's/peer/md5/' /etc/postgresql/9.4/main/pg_hba.conf


 http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge
	$ psql -U <qualquer usuario> -c "SELECT NOW()"
	psql: FATAL: Peer authentication failed for user "<qualquer usuario>"

	se ocorreu mesmo após executar:
	$ sudo sed -i -E 's/host\sall\sall\s127.0.0.1\/32\speer/host all all 127.0.0.1\/32 md5/' /etc/postgresql/9.4/main/pg_hba.conf

	subistituir todos os "peer" por "md5"
	$ sudo sed -i -E 's/peer/md5/' /etc/postgresql/9.4/main/pg_hba.conf


	http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge