On Wed, Sep 13, 2006 at 03:43:15PM -0700, Peter Abrahamsen wrote:
> Hi all,
> 
> I've searched for this error and haven't come up with anything.
> 
> I'm turnning postgresql 7.4.13 on Gentoo, with slony1 1.1.5 installed
> from portage.
> 
> Everything seems fine until I go to run
> # slonik < init_cluster.slnk
> as per the instructions at:
> http://www.varlena.com/GeneralBits/113.php
> 
> I get the error:
> PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  could not load
> library "/usr/lib64/posgresql/xxid.so": /usr/lib64/postgresql/xxid.so:
> undefined symbol: GetTopTransactionId

This means that while installing that the xxid.so file did not get
put into the right directory, $PGLIB.  If your *postgres* prefix is /usr/local/pgsql
then PGLIB is /usr/local/pgsql/lib.   If you have to fish around,
it is the same directory that plpgsql.so lives.  Move or link
the file there.

Note that after this error you will also receive the same error for
slony_funcs.so.  Then later on Perl will not find slon-tools.pm.
These also need to go into the PGLIB directory.

The configuration options are confusing and depend on the type of
installation of postgresql that you have.  Especially when that installation
is spread around /usr/bin, /usr/lib, etc.

--elein
elein at varlena.com


> 
> slony1 configure shows:
> checking whether GetTopTransactionId is declared... no
> 
> Postgresql was compiled with libg++, nls, pam, perl, pg-hier,
> readline, ssl, xml, threads, and zlib support.
> 
> Many thanks in advance for any insight,
> 
> Peter
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>