Thanks Guys, this is really useful, especially the pg_service.conf. I have got an app where the connection parameters have to be set in 3 different places I was thinking of writing something myself but now that I know of pg_service.conf, problem solved. Regards, Val --- On Tue, 22/7/08, Jeffrey Baker <jwbaker@xxxxxxxxx> wrote: > From: Jeffrey Baker <jwbaker@xxxxxxxxx> > Subject: Re: [PERFORM] Perl/DBI vs Native > To: "Greg Sabino Mullane" <greg@xxxxxxxxxxxx> > Cc: pgsql-performance@xxxxxxxxxxxxxx > Date: Tuesday, 22 July, 2008, 9:35 PM > On Tue, Jul 22, 2008 at 9:48 AM, Greg Sabino Mullane > <greg@xxxxxxxxxxxx> wrote: > >> In case someone is wondering, the way to force DBI > to use unix > >> sockets is by not specifying a host and port in > the connect call. > > > > Actually, the host defaults to the local socket. Using > the port > > may still be needed: if you leave it out, it simply > uses the default > > value (5432) if left out. Thus, for most purposes, > just leaving > > the host out is enough to cause a socket connection on > the default > > port. > > For the further illumination of the historical record, the > best > practice here is probably to use the pg_service.conf file, > which may > or may not live in /etc depending on your operating system. > Then you > can connect in DBI using dbi:Pg:service=whatever, and > change the > definition of "whatever" in pg_service.conf. > This has the same > semantics as PGSERVICE=whatever when using psql. It's > a good idea to > keep these connection details out of your program code. > > -jwb > > -- > Sent via pgsql-performance mailing list > (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance __________________________________________________________ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
