Re: Remote administration functionality

[Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>]

Luke Lonergan wrote:
> Bruce,
> 
> On 7/31/05 6:58 AM, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> 
> > TODO has:
> > 
> >         o Allow pg_hba.conf settings to be controlled via SQL
> > 
> >           This would require a new global table that is dumped to flat file
> > for
> >           use by the postmaster.  We do a similar thing for pg_shadow
> > currently.
> > 
> > I was thinking of a global table that can be modified with
> > INSERT/UPDATE/DELETE and is then dumped to a flat file, like we do with
> > pg_shadow.  For changing the file, I think we would need a sequence
> > number for each row.  In fact, perhaps it should act like a float, so if
> > you insert row sequence number 2.5, it goes between rows 2 and 3, and
> > then the rows are renumbered, perhaps automatically.  This is how APL
> > programming used to work, if I remember correctly.
> 
> This sounds great.
> 
> Has there been any agreement or a concept for remote reboot?

Reload of config file and rotate log files were part of the original
patch that I will try to apply.  I am not sure how remote restart would
work.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073