On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote: > Hi, > Here's what happens when I specify the port number > > [EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123 > psql: could not connect to server: Connection refused > Is the server running on host "127.0.0.1" and accepting > TCP/IP connections on port 5000?
Since that command without "-h 127.0.0.1" does work, the clear implication is that somehow there is a postmaster listening on port 5000 to Unix sockets and a different postmaster, presumably with a different pg_hba.conf, listening on port 5432 on 127.0.0.1. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/