Re: psql: FATAL: Ident authentication failed for user "postgres"

2008/9/8 VG <vikasraigupta(at)gmail(dot)com>:
> 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