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

Re: OT - pg perl DBI question

From: adam_pgsql <adam_pgsql(at)witneyweb(dot)org>
To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: OT - pg perl DBI question
Date: 2008-01-29 13:30:04
Message-ID: 5204BD2A-FD45-48DB-AF22-5D45604BA15E@witneyweb.org (view raw or flat)
Thread:
Lists: pgsql-general
this looks to be using the Pg module rather than DBI + DBD::Pg. This  
one i think:

http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz

i think thats quite old now though....


On 29 Jan 2008, at 13:10, Glyn Astill wrote:

> well its using the pgsql_replication_check.pl, which does:
>
> ----------------------
> use Pg;
> use Getopt::Std;
>
> our ($opt_h, $opt_d, $opt_p, $opt_U, $opt_w, $opt_c) = '';
> my ($conn, $res, $status, @tuple);
> my $query = 'SELECT * FROM replication_status' ;
> my @rep_time;
> ---------------------------------------
>
> But the error I ge t is:
>
> an't locate Pg.pm in @INC (@INC contains: /etc/perl
> /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5
> /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8
> /usr/local/lib/site_perl .) at psql_replication_check.pl line 12.
> BEGIN failed--compilation aborted at psql_replication_check.pl line
> 12.
>
> So I assume it's not getting past the use Pg line as although it's
> looking in /usr/lib/perl5 it's not going to look in
> /usr/lib/perl5/DBD ??
>
>
> --- CaT <cat(at)zip(dot)com(dot)au> wrote:
>
>> On Tue, Jan 29, 2008 at 04:45:48AM -0800, Glyn Astill wrote:
>>> Should the subdirectory DBD be in there? Perl was setup using
>> apt.
>>
>> How are you using it and what's your DBI db connect line?
>>
>> I'm about to go to sleep so if I don't reply it'll be because I'm
>> unconcious. :)
>>
>> -- 
>>    "To the extent that we overreact, we proffer the terrorists the
>>    greatest tribute."
>>    	- High Court Judge Michael Kirby
>>
>
>
>
>      __________________________________________________________
> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/


In response to

Responses

pgsql-general by date

Next:From: Colin WetherbeeDate: 2008-01-29 13:30:09
Subject: Re: OT - pg perl DBI question
Previous:From: Richard HuxtonDate: 2008-01-29 13:25:21
Subject: Re: OT - pg perl DBI question

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