Re: [GENERAL] Multiple postgresql installations on one machine.

2001-10-13 Thread Lincoln Yeoh
Thanks. I didn't know psql -h did that, thought it was for hostnames only :). So I resorted to TCP access for the rest of the installations and moved the sockets out of the way. However the Redhat style initscript tends to shutdown all installations - even though I specified a different PID file

Re: [GENERAL] Multiple postgresql installations on one machine.

2001-10-13 Thread Tom Lane
Charles Tassell <[EMAIL PROTECTED]> writes: > I may be wrong, but I don't think it's possible to have them on the same > port. The problem is that the TCP/IP port defaults to the same as the UNIX > sockets port, and UNIX sockets are local to the machine, so they are > completely independent of

Re: [GENERAL] Multiple postgresql installations on one machine.

2001-10-12 Thread Charles Tassell
I may be wrong, but I don't think it's possible to have them on the same port.  The problem is that the TCP/IP port defaults to the same as the UNIX sockets port, and UNIX sockets are local to the machine, so they are completely independent of IP addresses and can not be duplicated.  It is possibl

[GENERAL] Multiple postgresql installations on one machine.

2001-10-12 Thread Lincoln Yeoh
Hi, Is it possible to have multiple postgresql installations on one machine running on the same port but on different IP addresses? I've specified different IPs/hostnames for the virtual_host but the unix socket clashes when I try. Should I just move the unix sockets somewhere else with -k, wh