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

making contact via perl

From: "Stephen Choularton" <mail(at)bymouth(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: making contact via perl
Date: 2005-03-30 01:12:33
Message-ID: 000001c534c5$92540a30$9701a8c0@Tablet (view raw or flat)
Thread:
Lists: 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
 

Responses

pgsql-novice by date

Next:From: John DeSoiDate: 2005-03-30 03:15:40
Subject: Re: making contact via perl
Previous:From: CimaDate: 2005-03-29 20:48:04
Subject: Calling Stored Procedures from PHP

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