Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Perl/DBI vs...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 4178 of 4361
Post > Topic >>

Re: Perl/DBI vs Native

by greg@[EMAIL PROTECTED] ("Greg Sabino Mullane") Jul 22, 2008 at 04:48 PM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> In case someone is wondering, the way to force DBI to use unix
> sockets is by not specifying a host and ****t in the connect call.

Actually, the host defaults to the local socket. Using the ****t
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
****t.

For completeness in the archives, you can also specify the complete
path to the unix socket directory in the host line, for those cases in
which the socket is not where you expect it to be:

$dbh = DBI->connect('dbi:Pg:dbname=test;host=/var/local/sockets',
 $user, $pass, {AutoCommit=>0, RaiseError=>1});

- --
Greg Sabino Mullane greg@[EMAIL PROTECTED]
 Point Cor****ation
PGP Key: 0x14964AC8 200807221248
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkiGD1UACgkQvJuQZxSWSsjHTQCfYbGnh3dvs9ggZX0FCSwMro81
sJsAoOUcDyu6vQM43EJOGAay/vXyKWES
=hYLf
-----END PGP SIGNATURE-----



-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 1 Posts in Topic:
Re: Perl/DBI vs Native
greg@[EMAIL PROTECTED] (  2008-07-22 16:48:42 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Oct 15 20:53:41 CDT 2008.