Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group