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
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 |