postgres authentication

Поиск
Список
Период
Сортировка
От acchung@mit.edu
Тема postgres authentication
Дата
Msg-id 1026334114.3d2c9da2be9e0@webmail.mit.edu
обсуждение исходный текст
Ответы Re: postgres authentication  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
Hi,

 I changed my pg_hba.conf file so that I am authenticating using
md5 from passwdfile which is a file i created to hold my passwords.
I didn't add postgres onto that file but when I type psql template1
under postgres, it prompts me for my password.  i type it in
and it gives me

 psql: FATAL 1:  Password authentication failed for user "postgres"

 I only have one password for postgres which I used perfectly fine
to log into linux.  I also use the same password to switch between
 postgres and other non-root users in the bash shell.  i tried adding postgres
into the passwdfile file but to no avail.  How do I correct this
 password bug for postgres so that  I can do stuff as a superuser?
HELP!

 Alex



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

Предыдущее
От: Nathan Hill
Дата:
Сообщение: XML to Postgre conversion
Следующее
От: Kevin Brannen
Дата:
Сообщение: alter table modify column?