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://www.depesz.com/index.php/2007/10/04/ident/ what's in pg_hba.conf? > My file permission are: > drwx------ 5 postgres postgres 4096 2008-09-06 00:36 base > drwx------ 2 postgres postgres 4096 2008-09-08 21:44 global > drwx------ 2 postgres postgres 4096 2008-09-06 00:36 pg_clog > -rw-r--r-- 1 postgres postgres 3200 2008-09-08 21:35 pg_hba.conf > -rw------- 1 postgres postgres 1460 2008-09-06 00:36 pg_ident.conf > drwx------ 2 postgres postgres 4096 2008-09-08 15:52 pg_log > drwx------ 4 postgres postgres 4096 2008-09-06 00:36 pg_multixact > drwx------ 2 postgres postgres 4096 2008-09-06 00:36 pg_subtrans > drwx------ 2 postgres postgres 4096 2008-09-06 00:36 pg_tblspc > drwx------ 2 postgres postgres 4096 2008-09-06 00:36 pg_twophase > -rw------- 1 postgres postgres 4 2008-09-06 00:36 PG_VERSION > drwx------ 3 postgres postgres 4096 2008-09-06 00:36 pg_xlog > -rw------- 1 postgres postgres 15336 2008-09-06 00:36 postgresql.conf > -rw------- 1 postgres postgres 49 2008-09-08 21:44 postmaster.opts > -rw------- 1 postgres postgres 46 2008-09-08 21:44 postmaster.pid > > How could i achieve this.. > Regards, > Vikas > > > -- Filip Rembiałkowski -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
