Skip site navigation (1) Skip section navigation (2)

Re: Psql errors

From: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Psql errors
Date: 2008-12-23 18:10:58
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Well, this is sort of interesting.  I'm running Solaris 10.  The  
problem was that I didn't export all of the necessary shared  
libraries.  What's interesting is that it seems to matter what order  
these are in, in the path.  If I export LD_LIBRARY_PATH and I put the  
library identified as the "libdir" in the arguments for ./configure  
first, it works, if I put it at that end it doesn't.


On Dec 22, 2008, at 11:50 PM, Tom Lane wrote:

> Carol Walter <walterc(at)indiana(dot)edu> writes:
>> I just installed Postgres 8.3.4.  I have an instance of 8.2.4 running
>> on the same box.  When I start psql I get errors as follows:
>> ...
>> template1=# \l
>> psql: fatal: relocation error: file /db02/postgres/bin/psql:
>> symbol pg_valid_server_encoding_id: referenced symbol not found
> pg_valid_server_encoding_id is exported by the 8.3 version of  
> but not by 8.2.  So the problem here is that your 8.3 psql is binding
> to the wrong version of  You didn't say what the platform
> is, but the issue is probably related to the search path used to find
> shared libraries.
> It would probably work to just overwrite the 8.2 library with 8.3
> --- it should be backwards compatible.  (Better save a backup copy
> in case not, of course.)
> 			regards, tom lane
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-admin by date

Next:From: Scott MarloweDate: 2008-12-23 18:16:36
Subject: Re: Psql errors
Previous:From: Magnus HaganderDate: 2008-12-23 08:54:23
Subject: Re: publishing changelogs on pgweb

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group