Re: OT - pg perl DBI question

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/