Re: control pg_hba.conf via SQL

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: control pg_hba.conf via SQL
Дата
Msg-id 60zmj7q10b.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на control pg_hba.conf via SQL  (BERTHOULE Emmanuel <pgdev@manberth.homeip.net>)
Список pgsql-hackers
tgl@sss.pgh.pa.us (Tom Lane) writes:
> If your pg_hba.conf looks like
>     host    all    all    0.0.0.0/32    md5
> there's not much call to update it dynamically ...

There's one case, where .pgpass got hosed, and you didn't have a
backup of it, and need to assign new passwords...

I once ran into a case like this, where nobody had bothered to record
the "postgres" user's password, and had to override md5 authentication
in order to get in and reset passwords...
-- 
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/lisp.html
"When  I was a  boy of  fourteen, my  father was  so ignorant  I could
hardly  stand to  have  the  old man  around.  But when  I  got to  be
twenty-one, I  was astonished at how  much the old man  had learned in
seven years." -- Mark Twain


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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: control pg_hba.conf via SQL
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: control pg_hba.conf via SQL