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

From Cao Van Khanh
Subject Re: Users and multiple server environment
Date
Msg-id C45BCBD93973B84799EC3C3450A4372D9FF258@mailserver.cmc.com.vn
Whole thread Raw
In response to Users and multiple server environment  (Michael Long <mlong@datalong.com>)
List pgsql-admin
Try :
./psql -d template1




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

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

---------------------------(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



pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Failover Solution for Postgres
Next
From: Bruce Momjian
Date:
Subject: Re: Enabling --log-update