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

From: VG <vikasraigupta(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: psql: FATAL: Ident authentication failed for user "postgres"
Date: 2008-09-08 10:09:33
Message-ID: c4fdd6d00809080309n7e400b00m1018354a64c5c74e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Filip Rembiałkowski 2008-09-08 10:22:04 Re: psql: FATAL: Ident authentication failed for user "postgres"
Previous Message Frank Bax 2008-09-05 21:55:35 Re: variables with SELECT statement