Re: question about 2 versions and libraries

On Mon, 2002-05-27 at 09:25, Tina Messmann wrote:
> Hello List,
> i have version 7.1.3 (debian package) and version 7.2.1 (compiled from
> source) an the same box.

There is a Debian package of 7.2.1

> both versions (server and client programs) use the libs from the debian
> installation.
> i found a few postings with this topic and there is said to set
> LD_LIBRARY_PATH to the correct lib path.
> i did this but still the libs from the debian installation are used
> (despite of libpg.so.2):
>
> arwen:~# set |grep LD
> LD_LIBRARY_PATH=/usr/local/postgresql7.2.1/lib
> arwen:~# ldd /usr/local/postgresql7.2.1/bin/psql
>        libpq.so.2 => /usr/local/postgresql7.2.1/lib/libpq.so.2 (0x40016000)

This is from /usr/local (that is, your local build and not the Debian
package).  What is the problem?

>        libcrypt.so.1 => /lib/libcrypt.so.1 (0x400d8000)
>        libresolv.so.2 => /lib/libresolv.so.2 (0x40105000)
>        libnsl.so.1 => /lib/libnsl.so.1 (0x40117000)
>        libdl.so.2 => /lib/libdl.so.2 (0x4012c000)
>        libm.so.6 => /lib/libm.so.6 (0x40130000)
>        libreadline.so.4 => /lib/libreadline.so.4 (0x40152000)
>        libc.so.6 => /lib/libc.so.6 (0x40178000)
>        libncurses.so.5 => /lib/libncurses.so.5 (0x4029b000)
>        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
> arwen:~#
>
> and another problem is arising with LD_LIBRARY_PATH set
> (unix_socket_directory is set to /var/run/postgresql in postgresql.conf):
> arwen:~# /usr/local/postgresql7.2.1/bin/psql -p 6543 template1
> psql: could not connect to server: No such file or directory
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.6543"?

Have you started the postmaster on that port?

Are you looking at the right postgresql.conf?  The Debian file
/etc/postgresql/postgresql.conf is the target of a symbolic link from
$PGDATA/postgresql.conf.  The file you need to change is in the PGDATA
for your 7.2.1 postmaster.  If you want it to be the same as for the
Debian package, you must make a symbolic link there to
/etc/postgresql/postgresql.conf.  Otherwise it will use the default
created by initdb.

Have you got PGDATA set correctly in both your client and your
postmaster environments?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "All that the Father giveth me shall come to me; and
      him that cometh to me I will in no wise cast out."
                                      John 6:37