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 IP addresses and can not be duplicated.
Unix sockets need to have unique pathnames in the local filesystem. The PG "port number" is actually only a component of the file name. So all you need to do if you need to have conflicting port numbers is to vary the unix_socket_directory parameter for each postmaster. However, varying the port number is probably a simpler attack... >> I can't seem to tell psql where to find the moved unix socket. Use -h /path/to/directory/containing/socket. AFAIR you can set the path in PGHOST environment variable, if that helps. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly