Re: Connecting via Unix sockets?

[Dieter S. <dsi...@sq...>]

The string you want to change is in User.pm

The user.conf (older versions user.config) is created every time you make
a change, so to make it permanent change the User.pm file.

  # connect string to pass to dbi for database access
  if ($self->{dbdriver} eq "Pg") {
    $self->{dbconnect} = "dbi:Pg:dbname=$self->{dbname};host=$self->{dbhost};por
t=$self->{dbport}";
  }


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sun, 19 Aug 2001, Alan Hodgson wrote:

> On Mon, Aug 20, 2001 at 09:56:12AM +0800, Federico Sevilla III wrote:
> > Hi everyone,
> > 
> > I am not as much into Perl as I am into PHP4, but I was wondering, will it
> > be possible to configure SQL Ledger to possibly connect to PostgreSQL via
> > Unix sockets? Aside from a theoretical speed increase (however unfelt),
> > forcing the postmaster to not listen on TCP might be a good security move
> > for certain sites. On PHP4 this can be done by setting the protocol from
> > tcp to unix. I don't know if this can be done with SQL-Ledger and Perl.
> > Any gives?
> 
> Edit <user>.config.  Remove the host= and port= from the dbconnect string.
> I'm using an older version, but something similar should still apply.
> DBD::Pg will connect via UNIX domain socket by default. 
> 
> 
>