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

Re: Connect to postgresql database using Perl

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Connect to postgresql database using Perl
Date: 2010-03-31 07:25:33
Message-ID: k2zd5b05a951003310025ga932dc0es970fa94ce265ead5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Thanks Guys. DBI works fine. I have written below code but it executes only
on the server where I installed postgresql. Is there any way to run this
code from remote host. I get an error when trying to run it from remote
host. I think it is obvious because in below code there is no information
where to connect to. Could you please help me out.

use DBI;
$DB_name    = 'mydb';
$DB_user    = 'postgres';
$DB_pwd     = '';
$dbh = DBI->connect("dbi:Pg:dbname=$DB_name","$DB_user","$DB_pwd");
if ( !defined $dbh ) { die "Cannot connect to database!\n"; }
$sth  = $dbh->prepare("SELECT * FROM mytable");
$sth->execute();
while ( ($id,$name) = $sth->fetchrow_array() ) {  print "$id\t\t $name \n";
}
$sth->finish();
$dbh->disconnect();

*remote-host# perl pg-connect.pl
DBI connect('dbname=sysdb','postgres',...) failed: could not connect to
server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"? at
pg-connect.pl line 7
Cannot connect to database!
*
Thanks,
Dipti

On Wed, Mar 31, 2010 at 11:53 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>wrote:

> Hello
>
> 2010/3/31 dipti shah <shahdipti1980(at)gmail(dot)com>:
> > Hi,
> >
> > Could anyone please provide me an example to connect to a postgresql
> > database using Perl language and accessing the tables, schemas, and other
> > postgresql objects.
> >
>
> http://www.felixgers.de/teaching/perl/perl_DBI.html
> http://structbio.vanderbilt.edu/chazin/wisdom/dbi_howto.html
>
> Regards
>
> Pavel Stehule
>
> > Thanks,
> > Dipti
> >
>

In response to

Responses

pgsql-novice by date

Next:From: John R PierceDate: 2010-03-31 07:43:50
Subject: Re: Connect to postgresql database using Perl
Previous:From: Pavel StehuleDate: 2010-03-31 06:23:25
Subject: Re: Connect to postgresql database using Perl

pgsql-general by date

Next:From: Carsten KropfDate: 2010-03-31 07:35:17
Subject: Force PostgreSQL to query a custom index structure
Previous:From: Pavel StehuleDate: 2010-03-31 06:23:25
Subject: Re: Connect to postgresql database using Perl

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