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