Re: Notes on implementing URI syntax for libpq - Mailing list pgsql-hackers

From Alexander Shulgin
Subject Re: Notes on implementing URI syntax for libpq
Date
Msg-id 1322335924-sup-8500@moon
Whole thread Raw
In response to Re: Notes on implementing URI syntax for libpq  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Excerpts from Peter Eisentraut's message of Thu Nov 24 22:05:09 +0200 2011:
>
> On tor, 2011-11-24 at 15:43 +0200, Alexander Shulgin wrote:
> > Huh?  The service definitions are read from a local pg_service.conf,
> > and are specified by setting PGSERVICE (and PGSERVICEFILE) environment
> > variables, no?
> >
> > What would you do with such URI if you need to other people to connect
> > to the same service?  Send them URI along with the pg_service.conf?
>
> A full URI would also rely on host names or IP addresses being the same
> everywhere.  It's all a matter of degree ...

True, but it is much more reasonable to expect that hostnames will resolve to the same addresses most of the time (save
forzone changes propagation time.) 

Still I can imagine where this may be useful, like local networks with shared pg_service.conf files.  And since we
don'tneed to do anything special to support the behavior (i.e. postgresql:///?service=foo is going to work out of the
box,)this seems to be a non-problem. 

--
Alex


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Command Triggers
Next
From: Dimitri Fontaine
Date:
Subject: Re: Prep object creation hooks, and related sepgsql updates