103 reputation
2
bio website
location
age
visits member for 4 years, 5 months
seen Oct 7 at 14:14

Aug
27
awarded  Scholar
Aug
27
awarded  Supporter
Aug
27
accepted PostgreSQL password issue with psql
Aug
27
comment PostgreSQL password issue with psql
Yep, this did the trick, finally I'm inside psql console!!! Though I need to use local all postgres trust, not peer.
Aug
27
comment PostgreSQL password issue with psql
When I put local all postgres peer, restart the postgres instance, and try bin/psql I get FATAL: Peer authentication failed for user "postgres" and a log statement saying LOG: provided username (postgres) and authenticated username (myusername) do not match When I put local all postgres trust instead, I get FATAL: role "postgres" does not exist
Aug
27
asked PostgreSQL password issue with psql