Oliver Elphick wrote:
>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
>
i know this, but i want to keep the old version as long as i know that
everything is working with 7.2.1
[snip....]
>
>This is from /usr/local (that is, your local build and not the Debian
>package). What is the problem?
>
uh...no problem, sorry about that...
[snip...]
>>
>>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?
>
yes. 7.1.3 (deb package) is listening on 5432, 7.2.1 (from tarball) is
listening on 6543
>
>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.
>
arwen:~# cat /var/lib/postgres7.2.1/data/postgresql.conf |grep unix_socket_dir
unix_socket_directory = '/var/run/postgresql'
arwen:~#
i solved this problem now by setting PGHOST to /var/run/postgresql (is
this the common solution?)
>
>Have you got PGDATA set correctly in both your client and your
>postmaster environments?
>
no, i didn'd do that, where is the best place to set this variable for
the client environment? is it .profile or profile?
but what happens when then calling the debian version? hmmm...should be
no problem, since the commands from the debian package uses a wrapper
that sets the environment correctly, am i right with that?
Thank you for the help.
Tina