making contact via perl - Mailing list pgsql-novice

From Stephen Choularton
Subject making contact via perl
Date
Msg-id 000001c534c5$92540a30$9701a8c0@Tablet
Whole thread Raw
Responses Re: making contact via perl
List pgsql-novice

Hi

 

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

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Drawing schema
Next
From: John DeSoi
Date:
Subject: Re: making contact via perl