Marina Olhovsky wrote:
Hello,
I'm trying to assign a password for a postgres user. I've logged in
as postgres, issued "alter user my_user with password 'my_passwd'".
Doing "select * from pg_users" shows the new user with password
assigned. However, when I try to start psql as the new user: "psql
-U my_user -W" and enter my_passwd as password, I get "Ident
authentication failed" error. Could someone please help ASAP? TIA.
Do you already have other users that can log in to psql? What does you
pg_hba.conf file have? Can you create the user successfully with createuser?
Have you read the docs thoroughly?
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
brian
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
