Re: [GENERAL] Can't connect to postgresql using 'psql -d database -U user -W'

2006-01-05 Thread Rick Ellis
In article <[EMAIL PROTECTED]>, ctobini <[EMAIL PROTECTED]> wrote: >tobini% psql -d template1 -U postgres -W >password: postgres >psql: FATAL: IDENT authentication failed for user "postgres" > >Do you have an idea about this problem ? Use the su command to become user postgres and then run the p

Re: [GENERAL] Can't connect to postgresql using 'psql -d database -U user -W'

2006-01-05 Thread Larry Rosenman
ctobini wrote: > Hello, > > I have a problem with postgresql 7.4 installed on Linux Ubuntu 5.04 > (hoary). > > I made an 'alter' command for my db users : > > eg: alter user postgres with password 'postgres'; > ALTER USER > > but I can't connect to postgresql using : > > tobini% psql -d templa

[GENERAL] Can't connect to postgresql using 'psql -d database -U user -W'

2006-01-05 Thread ctobini
Hello, I have a problem with postgresql 7.4 installed on Linux Ubuntu 5.04 (hoary). I made an 'alter' command for my db users : eg: alter user postgres with password 'postgres'; ALTER USER but I can't connect to postgresql using : tobini% psql -d template1 -U postgres -W password: postgres psq