On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote:
> Hi,
> Here's what happens when I specify the port number
>
> [brakesh@lnx383 ~]$ 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 olly@lfix.co.uk
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