Re: [SQL] psql: FATAL: Ident authentication failed for user "postgres"

2008-09-08 Thread Devrim GÜNDÜZ
On Mon, 2008-09-08 at 15:39 +0530, VG wrote: > hba.conf group and owner were postgres then i changed it to root. > > when i type psql -U postgres command ( as root user) I get: > > psql: FATAL: Ident authentication failed for user "postgres" First, revert the owner/group change. Then, su - po

Re: [SQL] psql: FATAL: Ident authentication failed for user "postgres"

2008-09-08 Thread Milen A. Radev
VG написа: > Hi, > > I have installed postgresql-serve using yum > hba.conf group and owner were postgres then i changed it to root. Why? > > when i type psql -U postgres command ( as root user) I get: > > psql: FATAL: Ident authentication failed for user "postgres" Most probably the defau

Re: [SQL] psql: FATAL: Ident authentication failed for user "postgres"

2008-09-08 Thread Filip Rembiałkowski
2008/9/8 VG <[EMAIL PROTECTED]>: > Hi, > > I have installed postgresql-serve using yum > hba.conf group and owner were postgres then i changed it to root. > > when i type psql -U postgres command ( as root user) I get: > > psql: FATAL: Ident authentication failed for user "postgres" > read http:

[SQL] psql: FATAL: Ident authentication failed for user "postgres"

2008-09-08 Thread VG
Hi, I have installed postgresql-serve using yum hba.conf group and owner were postgres then i changed it to root. when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident authentication failed for user "postgres" My file permission are: drwx-- 5 postgres postgres 40