I have gone through many SO question answer my problem was not solved..
This is the method I tried:
user@user-Latitude-XT3:~$ sudo su postgres
No passwd entry for user 'postgres'
user@user-Latitude-XT3:~$
and many others.
I keep on getting fatal error user does not exist
any working solution?
please Note before marking duplicate, tried all similar but wasn't solved yet.
This is how I normally login to postgres:
sudo -i
sudo -i -u postgres
psql
Here how i fixed,
vi /etc/postgresql/9.3/main/pg_hba.conf
local all postgres peer
here change peer to trust
restart, sudo service postgresql restart
now try, psql -U postgres
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With