Re: pg_service.conf ?

On Mon, Mar 13, 2006 at 10:57:03PM -0500, Christopher Browne wrote:
> david(at)fetter(dot)org (David Fetter) wrote:
> > Folks,
> >
> > It doesn't appear that the JDBC driver knows about
> > pg_service.conf. If that's so, would it be a big challenge to add
> > that feature?
> >
> > Thanks in advance for any hints, tips, pointers, &c. :)
>
> Yeah, that would be a pretty slick thing.
>
> We're starting to look at this; using it initially so DBA accounts
> only need one PG value set to get psql to work.

That would be a Very Good Thing(TM)

> It's *tempting* to use pg_service.conf to control Slony-I. There's
> a fragility to it in that pg_service.conf has to be kept consistent
> on all the relevant servers, although that would normally be just
> one server per site...

That's true.

> .pgpass support is under way, right? That's better than
> pg_service.conf :-).

They shouldn't be mutually exclusive :)

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!