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

Поиск
Список
Период
Сортировка
От VG
Тема psql: FATAL: Ident authentication failed for user "postgres"
Дата
Msg-id c4fdd6d00809080309n7e400b00m1018354a64c5c74e@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql: FATAL: Ident authentication failed for user "postgres"  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
Re: psql: FATAL: Ident authentication failed for user "postgres"  ("Milen A. Radev" <milen@radev.net>)
Re: psql: FATAL: Ident authentication failed for user "postgres"  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-sql
<div dir="ltr">Hi,<br /><br />I have installed postgresql-serve using yum <br />hba.conf group and owner were postgres
theni changed it to root.<br /><br />when i type psql -U postgres command ( as root  user) I get:<br />  <br /> psql:
FATAL: Ident authentication failed for user "postgres"<br /><br />My file permission are:<br />drwx------ 5 postgres
postgres 4096 2008-09-06 00:36 base<br />drwx------ 2 postgres postgres  4096 2008-09-08 21:44 global<br /> drwx------
2postgres postgres  4096 2008-09-06 00:36 pg_clog<br />-rw-r--r-- 1 postgres postgres  3200 2008-09-08 21:35
pg_hba.conf<br/>-rw------- 1 postgres postgres  1460 2008-09-06 00:36 pg_ident.conf<br />drwx------ 2 postgres
postgres 4096 2008-09-08 15:52 pg_log<br /> drwx------ 4 postgres postgres  4096 2008-09-06 00:36 pg_multixact<br
/>drwx------2 postgres postgres  4096 2008-09-06 00:36 pg_subtrans<br />drwx------ 2 postgres postgres  4096 2008-09-06
00:36pg_tblspc<br />drwx------ 2 postgres postgres  4096 2008-09-06 00:36 pg_twophase<br /> -rw------- 1 postgres
postgres    4 2008-09-06 00:36 PG_VERSION<br />drwx------ 3 postgres postgres  4096 2008-09-06 00:36 pg_xlog<br
/>-rw-------1 postgres postgres 15336 2008-09-06 00:36 postgresql.conf<br />-rw------- 1 postgres postgres    49
2008-09-0821:44 postmaster.opts<br /> -rw------- 1 postgres postgres    46 2008-09-08 21:44 postmaster.pid<br /><br
/>Howcould i achieve this..<br />Regards,<br />Vikas<br /><br /><br /></div> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: variables with SELECT statement
Следующее
От: "Filip Rembiałkowski"
Дата:
Сообщение: Re: psql: FATAL: Ident authentication failed for user "postgres"