I am trying to connnect to Postgresql 9.1 database on remote ubuntu 12.04 server from my windows pc using putty.i have created user with password and when i run the command
psql -U opentaps -d opentaps (opentaps is the user i created for database opentaps) i get the below mesaage . psql: FATAL: password authentication failed for user "opentaps" i did try psql -U opentaps -d opentaps -h localhost but still same message after i supply the password . my password for the opentaps user is correct .also even when i try psql -U postgres -d postgres i get the same failure message .
I made some changes in pg_hba.conf and it looks like this
https://docs.google.com/document/d/13ymGYj9e7YPFiaffwixLzsWJygp_OfBmgBi4Axgrg5A/edit?usp=sharing
also in postgresql.conf i made the change by uncomenting listen_addresses = '*' i know i am missing something here .need your help to know what else i need to change to connect to the server.
thanks for your help
pg_hba.conf
orlisten_addresses
problem. Assuming certainty that it's the correct password, I'd check its validity withselect usename,valuntil from pg_user
. If you can't connect at all, replace temporarilymd5
withtrust
in pg_hba.conf to bypass the password. – Daniel Vérité