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