Re: Remote administration functionality

> -----Original Message-----
> From: Douglas McNaught [mailto:doug@mcnaught.org]
> Sent: 01 August 2005 15:16
> To: Dave Page
> Cc: Bruce Momjian; Tom Lane; Magnus Hagander; PostgreSQL-development
> Subject: Re: [HACKERS] Remote administration functionality
>
> "Dave Page" <dpage@vale-housing.co.uk> writes:
>
> >
> >
> >> -----Original Message-----
> >> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
>
> >> I am thinking we will need load_pg_hba() and
> write_pg_hba() that will
> >> load and write the table to pg_hba.conf.
> >
> > Yeah, that bit is straghtforward enough, but what about the
> situation
> > where dba #1 updates the pg_hba table, at the same time as dba #2 is
> > editting pg_hba.conf in vi?
>
> "Don't do that then."
>
> With this change, editing ph_hba.conf by hand should only be done when
> the database is down...

Don't tell me, tell all the users that log bugs when their changes get
lost because they didn't read that bit of the manual for whatever
version this might or might not end up in :-).

People are used to editting the file and hupping the server, and I would
guess few of us existing users re-read the pg_hba.conf manual pages when
setting up our shiny new version.

Regards, Dave.