Thread: making contact via perl

making contact via perl

From

"Stephen Choularton"

Date:

30 March 2005, 05:13:13

I appreciate this may not be the right place to post. If it isn’t please advise me of the correct site.

I am using windowsXP. I am trying to make contact with a psql database called mydb that is on my computer. I can do this at the prompt, viz:

C:\Documents and Settings\Stephen>psql mydb postgres

Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms

\h for help with SQL commands

\? for help with psql commands

\g or terminate with semicolon to execute query

\q to quit

Warning: Console code page (437) differs from Windows code page (1252)

8-bit characters may not work correctly. See psql reference

page "Notes for Windows users" for details.

And I know it is there:

mydb=# select * from weather;

city | temp_lo | temp_hi | prcp | date

---------------+---------+---------+------+------------

San Francisco | 46 | 50 | 0.25 | 1994-11-27

Hayward | 37 | 54 | | 1994-11-29

(2 rows)

but when I try to use this perl code to make contact:

use DBI;

use DBD::PgPP

my @drivers = DBI -> available_drivers();

print "this is it @drivers";

# 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

Stephen

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005

Re: making contact via perl

From

John DeSoi

Date:

30 March 2005, 07:16:02

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