| From: | "Ji Li" <jli(at)faxtel(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | DBI connection problem |
| Date: | 1999-05-27 17:08:54 |
| Message-ID: | 000701bea863$99c27800$a49577d8@netiger.faxtel.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, all
I am trying to write Perl script using DBI module to manupulate the database
on our virtual server.
I wrote the following code:
#! /usr/bin/perl5
use DBI;
$dbHandle = DBI->connect("DBI:Pg:dbname=best",'','') or $DBI::errstr;
$sql ="SELECT * FROM sample";
$statementHandle = $dbHandle->prepare($sql);
$statementHandle->excute() || die $statementHandle->errstr;
$arrayRef = $statementHandle->fetchall_arrayref;
$dbHandle->disconnect();
print $arrayRef ;
after compiling, I got the following error message:
connectDB() failed: Is the postmaster running and accepting connections at 'UNIX
Socket' on port '5432'?
at sample.pl line 4
but when I run
% psql
in the shell, everything works just OK.
Why my script cannot connect to the database? What I need to do for this?
Thanks a lot.
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 1999-05-27 17:24:50 | Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow |
| Previous Message | Bruce Momjian | 1999-05-27 15:17:00 | Re: [GENERAL] 6.4.2 on DEC Alpha |