password authentication failed for user postgres

Поиск
Список
Период
Сортировка
От Major Services
Тема password authentication failed for user postgres
Дата
Msg-id 375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com
обсуждение исходный текст
Ответы Re: password authentication failed for user postgres
Список pgsql-admin
Hi,

1. I have added  listen_addresses = '*' ; in  postgresql.conf

2. And have made the following changes to pg_hba.conf

local   DATABASE    USER   METHOD
local    samegroup      all      password
host    DATABASE    USER    CIDR-ADDRESS  METHOD  [OPTION]
host          all                 all       0.0.0.0/0             md5
hostssl      all                 all       0.0.0.0/0            md5

3. Have restarted the server

4. I can login to the server as user postgres.

But  while trying to createuser I get the following message  :
'createuser: could not connect to database postgres:  FATAL :
password authentication failed for user "postgres"

This is on Redhat running Plesk also.

I am new to Linux as well as PostgreSQL. Help would be much appreciated.

Thanks
Viv

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

Предыдущее
От: Andrzej Angowski
Дата:
Сообщение: Re: LATIN2 encoding and Polish_Poland locale
Следующее
От: Iñigo Martinez Lasala
Дата:
Сообщение: Re: password authentication failed for user postgres