I'm testing replication to the same master slave server. As outlined in
http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic.

xxid.so does exist in /var/lib/pgsql2/lib/xxid.so.

I do have two instances of postgres on the same box, the other copy is
located in /var/lib/pgsql/, however it is not running. I think this may be
the problem however when compiling the new pg source, I installed it to the
path /var/lib/pgsql2/. I can only assume the program slonik somehow, rather
than looking in /var/lib/pgsql2/lib/ it references in /var/lib/pgsql/lib/.

Any other suggestions :)? Has anyone successfully used slony-I with two
instances on the same machine. This is important as we use failover
redundancy across our production boxes, and there are up to three instances
of postgres running on different ports at any one time.


-----Original Message-----
From: Darcy Buskermolen [mailto:darcy at wavefire.com] 
Sent: Wednesday, 19 January 2005 10:37 AM
To: slony1-general at gborg.postgresql.org
Cc: Theo Galanakis; 'slony1-general at gborg.postgresql.org'
Subject: Re: [Slony1-general] Slony1 init script.


On January 18, 2005 02:39 pm, Theo Galanakis wrote:
> Hi, I'm getting the following error when attempting to run the script 
> outlined in 
> http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic
> <http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic>
> <stdin>:21: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not 
> access file "$libdir/xxid": No such file or directory
> <stdin>:21: Error: the extension for the xxid data type cannot be 
> loaded in database 'dbname=pgbench host=localhost user=postgres'

does xxid.so exist in $libdir on all nodes participating in the replication 
cluster?

> I have complied postgres from scratch with the following options: 
> ./configure --without-readline --prefix=/var/lib/pgsql2 --without-zlib 
> --enable-thread-safety Then ran through the usual install procedure 
> found in the INSTALL file.
>
> Then compiled slony:
> ./configure --with-pgsourcetree=/home/theog/postgresql-7.4.5/
> -- and installed as outlined in the above link.
> It have condsidered the problem may be that I have two versions of 
> postgres on the server one is a standard linux redhat rpm install 
> located in /var/lib/pgsql/, and the other is the one I build from 
> source located under /var/lib/pgsql2/... However I'm only running 
> "/var/lib/pgsql2/" at the time. Could this be causing the issue? What 
> should I be looking at?
>
>
> ______________________________________________________________________
> This email, including attachments, is intended only for the addressee 
> and may be confidential, privileged and subject to copyright.  If you 
> have received this email in error, please advise the sender and delete 
> it.  If you are not the intended recipient of this email, you must not 
> use, copy or disclose its content to anyone.  You must not copy or 
> communicate to others content that is confidential or subject to 
> copyright, unless you have the consent of the content owner.

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050119/629560fc/attachment-0001.html