Re: slony error --need help

From: Richard Huxton <dev(at)archonet(dot)com>
To: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
Cc: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: slony error --need help
Date: 2007-12-18 09:21:26
Message-ID: 47679116.7030401@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

SHARMILA JOTHIRAJAH wrote:
> I get theis error
>
> <stdin>:21: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not load library "/export/home/josh/postgres7.4/lib/xxid.so": ld.so.1: postgres: fatal: relocation error: file /export/home/josh/postgres7.4/lib/xxid.so: symbol GetTopTransactionId: referenced symbol not found
>
> <stdin>:21: Error: the extension for the xxid data type cannot be loaded in database 'dbname=testdb1 host=172.31.0.67 user=josh'
> <stdin>:21: ERROR: no admin conninfo for node 134701624

Does this file exist on the host in question?
Does the postgres user have permission to access it?
Is there anything else (e.g. selinux) that could interfere with access
to it?
What is different between your installations of 7.4, 8.1, 8.2 on host
172.31.0.67? Were they all compiled from source?

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mljv 2007-12-18 09:44:58 Restoring only some data from a backup file
Previous Message bookman bookman 2007-12-18 06:53:16 pgsql cannot read utf8 files moved from windows correctly!