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

Reply via email to