Re: Users and multiple server environment

Try :
./psql -d template1

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, October 04, 2004 5:25 AM
To: Michael Long
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Users and multiple server environment

Michael Long <mlong(at)datalong(dot)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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match