Re: Remote administration functionality - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Remote administration functionality
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C77F6@algol.sollentuna.se
Whole thread Raw
In response to Remote administration functionality  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Remote administration functionality  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> > > > I fail to see how this is better than just editing the
> > > file. Because
> > > > it basically *is* a file editing function limited to
> pg_hba.conf.
> > > > Perhaps what we need is a file reader/writer that is
> > > hardcoded to the
> > > > pg_hba.conf file?
> > >
> > > It allows remote administration, and by using columns for the
> > > pg_hba.conf lines (except for comments), we are making it
> somewhat
> > > easier.
> >
> > I fail to see a real use-case for somebody editing pg_hba.conf *by
> > hand* using this. I can see it happening through a tool like
> > phppgadmin or pgadmin, in which case this will actually
> make it *harder* to implement.
>
> Uh, not sure why it would be harder.  What system would be easier?
> Sure, file I/O works, but you can't even try to do that from psql.

Doing it from psql is the part I fail to see a real use-case for. The
people who would use psql for it would probably just use vi or emacs or
sed or whatever on the file itself.
If you needed to do it remotely, you could just call pqsl once to get
the data out to a local file, edit that file, and then call it again to
put it back on the server, no?

//Magnus


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Remote administration functionality
Next
From:
Date:
Subject: Re: psql as an execve(2) interpreter