Craig Ringer wrote: > On 6 November 2015 at 13:34, Robert Haas <robertmh...@gmail.com> wrote: > > >> But some options control how > >> next host should be choosen (i.e. use random order for load-balancing > >> or sequential order for high availability), so they should be specified > >> only once per connect string. > > > > But this seems like a point worthy of consideration. > > This makes me think that trying to wedge this into the current API > using a funky connection string format might be a mistake. > > Lots of these issues would go away if you could provide more than just > a connstring.
Yes, I agree. I wonder if the failover aspect couldn't be better covered by something more powerful than a single URI, such as the service file format. Maybe just allow the contents of a service file to be passed as a "connection string", so that the application/environment can continue to maintain the connection info as a string somewhere instead of having to have an actual file. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers