Re: Remote administration functionality

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