"Bhavana.Rakesh" <Bhavana.Rakesh@noaa.gov> writes:
> 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?
5000 being a nonstandard port number, it's certainly possible that the
kernel is filtering this connection attempt. "Connection refused" might
mean either that there's no process listening to TCP port 5000, or that
the kernel rejected the connection before looking for a listening process.
In any case it seems highly probable that you do have two postmasters
running on this machine, one at port 5000 and one at port 5432. The
psql calls without an explicit -p switch would have defaulted to port
5432 unless you've done something strange to your installation.
regards, tom lane