pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: dan@kwasar.biz
To: Michael Long <mlong@datalong.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Users and multiple server environment
Date: Sun,  3 Oct 2004 14:18:22 -0700
Message-ID: <1096838302.41606c9eee381@webmail.kwasar.biz> (raw)
In-Reply-To: <41606106.2080006@datalong.com>
References: <415F87D7.5000800@datalong.com>
	<28880.1096780739@sss.pgh.pa.us>
	<415F8EC5.9040504@datalong.com>
	<415F9A9F.6090500@datalong.com>
	<29421.1096785225@sss.pgh.pa.us>
	<415FA1FB.9000306@datalong.com>
	<3071.1096822055@sss.pgh.pa.us>
	<41606106.2080006@datalong.com>

Quoting Michael Long <mlong@datalong.com>:

>
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
>
> Is psql linked to the proper libraries?
>
> --This is version 7.3.2

Below looks okay.

> ldd /usr/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40015000)
>         libpam.so.0 => /lib/libpam.so.0 (0x4003a000)
>         libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x40042000)
>         libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x40072000)
>         libz.so.1 => /lib/libz.so.1 (0x40149000)
>         libreadline.so.4 => /lib/libreadline.so.4 (0x40158000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x40185000)
>         libresolv.so.2 => /lib/libresolv.so.2 (0x401b6000)
>         libnsl.so.1 => /lib/libnsl.so.1 (0x401c9000)
>         libdl.so.2 => /lib/libdl.so.2 (0x401de000)
>         libm.so.6 => /lib/libm.so.6 (0x401e1000)
>         libc.so.6 => /lib/libc.so.6 (0x40203000)
>         libncurses.so.5 => /lib/libncurses.so.5 (0x40339000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>

I've never installed 8.0b3, but I would guess that libpq is also found in
/usr/local. Check for a second copy there and modify LD_LIBRARY_PATH and/or
/etc/ld.so.conf (followed by ldconfig) on Linux to look there first.

> ldd /usr/local/pgsql_8.0b3/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)
>         libz.so.1 => /lib/libz.so.1 (0x40039000)
>         libreadline.so.4 => /lib/libreadline.so.4 (0x40049000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x40076000)
>         libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000)
>         libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000)
>         libdl.so.2 => /lib/libdl.so.2 (0x400ce000)
>         libm.so.6 => /lib/libm.so.6 (0x400d1000)
>         libc.so.6 => /lib/libc.so.6 (0x400f4000)
>         libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x4022a000)
>         libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x4025a000)
>         libncurses.so.5 => /lib/libncurses.so.5 (0x40331000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



view thread (13+ messages)  latest in thread

Message-ID: <1096838302.41606c9eee381@webmail.kwasar.biz>
Permalink:  ../1096838302.41606c9eee381@webmail.kwasar.biz/
Also on:    postgresql.org/message-id/1096838302.41606c9eee381@webmail.kwasar.biz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dan@kwasar.biz, mlong@datalong.com
  Subject: Re: Users and multiple server environment
  In-Reply-To: <1096838302.41606c9eee381@webmail.kwasar.biz>
  References: <415F87D7.5000800@datalong.com> <28880.1096780739@sss.pgh.pa.us> <415F8EC5.9040504@datalong.com> <415F9A9F.6090500@datalong.com> <29421.1096785225@sss.pgh.pa.us> <415FA1FB.9000306@datalong.com> <3071.1096822055@sss.pgh.pa.us> <41606106.2080006@datalong.com> <1096838302.41606c9eee381@webmail.kwasar.biz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox