Skip site navigation (1) Skip section navigation (2)

Re: control pg_hba.conf via SQL

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: control pg_hba.conf via SQL
Date: 2006-03-30 17:46:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) writes:
> If your pg_hba.conf looks like
> 	host	all	all	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(at)~S" "cbbrowne" "")
"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

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2006-03-30 18:27:25
Subject: Re: control pg_hba.conf via SQL
Previous:From: Chris BrowneDate: 2006-03-30 17:43:33
Subject: Re: control pg_hba.conf via SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group