Re: making contact via perl

From: John DeSoi <desoi(at)pgedit(dot)com>
To: "Stephen Choularton" <mail(at)bymouth(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: making contact via perl
Date: 2005-03-30 03:15:40
Message-ID: FEE7B6AC-A0C9-11D9-A297-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

You need to provide the host of the local machine in your connect
parameters (e.g. 127.0.0.1 or localhost). The /tmp directory reference
indicates that perl is trying to connect with a Unix domain socket
which is not supported on Windows. TCP/IP host connections only.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

On Mar 29, 2005, at 8:12 PM, Stephen Choularton wrote:

> # connecting to database
>
> my $database='mydb';
>
> my $username = 'postgres';
>
> my $password = '';
>
> my $dbh = DBI->connect("DBI:PgPP:$database",
>
>     "$username", "$password");
>
>  
>
> I get:
>
>  
>
> C:\DB>db.pl
>
> DBI connect('mydb','postgres',...) failed: Couldn't connect to
> /tmp/.s.PGSQL.543
>
> 2:  at C:/Perl/site/lib/DBD/PgPP.pm line 124
>
>  at C:\DB\db.pl line 15

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-03-30 05:36:50 Re: Connecting to database using pg_connect
Previous Message Stephen Choularton 2005-03-30 01:12:33 making contact via perl