Re: [ADMIN] Help! Regarding Pg for posgreSQL

2004-03-06 Thread VanderLeeden
Hi Amit,
you can check the pgperl Project -- pgperl
pgperl  is a native Perl interface to PostgreSQL. It clearly follows libpq's
API.
HomePage= http://gborg.postgresql.org/project/pgperl/projdisplay.php
The most recent version is Pg-2.0.2 and if you install it on your node it
will provide Pg.pm.
A typical connect call served by this library looks like:
  $masterConn = Pg::connectdb($connectString);
Good Luck!
Rudolf VanderLeeden

- Original Message - 
From: "Amit Kush" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 02, 2004 12:00 AM
Subject: [ADMIN] Help! Regarding Pg for posgreSQL


> Hi!
> I came to ur e-mail address from one of the sites through google. Hope u
> could help me please.
> I am using red hat linux and running my perl programs with postgresql at
> back end.
> The follwing error occurs while using Pg.
>
> 
> Can't locate Pg.pm in @INC (@INC contains:
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .)
> -
>
> Though on searching for Pg.pm it is found at the location
> /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/DBD/Pg.pm
>
> If I copy it this Pg.pm file in
> /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/, it does not
> give the above error but says connectdb() is an undefined subroutine.
>
> Any help will be highly appreciated.
> Regards
> Thanks
>
>

##
>
> AMIT KUSH
> Bioinformatics Centre (BIC)
> Institute of Microbial Technology
> CHANDIGARH - 160 036
> INDIA
>
> Phone : (0172) 2690279 (O)
> E-mail: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Web   : , 
>
>

##
>
>
>
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[ADMIN] DBMirror - Replicating binary objects of type bytea ?

2003-08-20 Thread VanderLeeden



Anyone has a clue of why the replication using 
DBMirror (PostgreSQL 7.3.4) 
does not replicate correctly if the primary key is 
of type "bytea" ?
Error message from  DBMirror.pl  is e.g.   ERROR:  Cannot insert a duplicate key into 
unique index payment_pkey
 
Second question:  Is a "manual" failover setup 
possible and recommended using DBMirror?
Any experiences out there?
 
Thanks,
Rudolf VanderLeeden
 
Logic United GmbH, Munich, GermanyPhone +4980-249-2933www.logicunited.com