Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group