On Wednesday 11 June 2008 16:54:23 Bruce Momjian wrote:
> Dave Page wrote:
> > On Wed, Jun 11, 2008 at 6:56 PM, Bruce Momjian <bruce@momjian.us> wrote:
> > > Dave Page wrote:
> > >> On Mon, Jun 2, 2008 at 5:46 AM, Joshua D. Drake <jd@commandprompt.com>
wrote:
> > >> > pg_ctl -D data check?
> > >> >
> > >> > I would +1 that.
> > >>
> > >> I would also really like to see that - though I'd also like to see an
> > >> SQL interface so we can check a config before saving when editing via
> > >> pgAdmin or similar.
> > >
> > > Should this be a TODO?
> >
> > Yes please.
>
> Added to TODO:
>
> * Add pg_ctl option to do a syntax check of postgresql.conf
>
ISTM we need something that can run inside the db as well, i'm thinking
something like pg_check_conf() to go with pg_reload_conf(). Also, these
should probably check validity of the pg_hba.conf as well.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL