SEO

permalink · #1 (**permalink**) 04-09-2008, 12:40 PM

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.

permalink · #2 (**permalink**) 04-09-2008, 12:40 PM

Marina Olhovsky <olhovsky@mshri.on.ca> schrieb:

>
> 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

Ident authentication means, that the actual user can identified with the
ident-service. I think, you should read more about authentification, for
instance there:

http://www.postgresql.org/docs/8.1/i...ntication.html

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

permalink · #3 (**permalink**) 04-09-2008, 12:41 PM

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/i...ntication.html

brian

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Ident authentication failed for user - URGENT