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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend