Changing default user's passwd

Поиск
Список
Период
Сортировка
От reshat.sabiq.1
Тема Changing default user's passwd
Дата
Msg-id Pine.SOL.4.43.0209111235320.3594-100000@herald.cc.purdue.edu
обсуждение исходный текст
Ответы Re: Changing default user's passwd
Список pgsql-novice
We've been trying to
alter user postgres with passwd '...' createdb createuser;
and the like, and we get
alter user
output showing that the command is successful.

However, when we later psql -U postgres postgres
we are getting:
psql: FATAL 1: IDENT authentication failed for user "postgres".

Is there a way to change this default user's password to avoid su'ing.

Thank you in advance,
r


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