Re: Users and multiple server environment - Mailing list pgsql-admin

From Tom Lane
Subject Re: Users and multiple server environment
Date
Msg-id 9756.1096842275@sss.pgh.pa.us
Whole thread Raw
In response to Re: Users and multiple server environment  (Michael Long <mlong@datalong.com>)
Responses Re: Users and multiple server environment  (Michael Long <mlong@datalong.com>)
Altering column type causes unstable server and data loss.  (Michael Long <mlong@datalong.com>)
List pgsql-admin
Michael Long <mlong@datalong.com> writes:
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity

> Is psql linked to the proper libraries?

> ldd /usr/local/pgsql_8.0b3/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)

Obviously not :-(.  This should be pointing to /usr/local/pgsql_8.0b3/lib/
so it seems you didn't do the rpath enabling correctly; or maybe your
system is configured in a way that overrides rpath (do you have
LD_LIBRARY_PATH set in your environment?).

I don't have any more advice than that to give; you may need to find a
Linux shared-library guru to help you fix it.

            regards, tom lane

pgsql-admin by date:

Previous
From: dan@kwasar.biz
Date:
Subject: Re: Users and multiple server environment
Next
From: Tsirkin Evgeny
Date:
Subject: Re: PLEASE GOD HELP US!