On Fri, Feb 03, 2006 at 08:05:48AM -0500, Mark Woodward wrote: > Like I said, in this thread of posts, yes there are ways of doing this, > and I've been doing it for years. It is just one of the rough eges that I > think could be smoother. > > (in php) > pg_connect("dbname=geo host=dbserver"); > > Could connect and query the dbserver, if the db is not on it, connect to a > database of known servers, find geo, and use that information to connect. > It sounds like a simple thing, for sure, but to be useful, there needs to > be buy in from the group otherwise it is just some esoteric hack.
It turns out what you like actually exists, lookup the "service" parameter in the connectdb string. It will read the values for the server, port, etc from a pg_service.conf file. There is an example in the tree but it looks something like the following: [servicename] dbname=blah user=blah pass=blah So all you need to specify is "service=servicename" and it will grab the parameters. This allows you to change the connection without changeing the code. Hope this helps, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
signature.asc
Description: Digital signature