Re: OT - pg perl DBI question

[adam_pgsql <adam_pgsql(at)witneyweb(dot)org>]

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/