postgres is running but can't connect port 5432 with it.
when i'm entering:-
# ps -ef | grep post
postgres 4278 1 0 11:19 ? 00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 4280 4278 0 11:19 ? 00:00:00 postgres: logger process
postgres 4282 4278 0 11:19 ? 00:00:00 postgres: writer process
postgres 4283 4278 0 11:19 ? 00:00:00 postgres: stats buffer process
postgres 4284 4283 0 11:19 ? 00:00:00 postgres: stats collector process
root 4897 3824 0 11:59 pts/2 00:00:00 grep post
this is it.
when i'm entering this, it is not showing port 5432 with postgres.
]# nmap 192.168.1.110
Starting Nmap 4.11 (
http://www.insecure.org/nmap/ ) at 2007-06-22 12:07 IST
Interesting ports on 192.168.1.110:
Not shown: 1668 closed ports
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
111/tcp open rpcbind
631/tcp open ipp
830/tcp open unknown
862/tcp open unknown
942/tcp open unknown
2049/tcp open nfs
5900/tcp open vnc
6000/tcp open X11
8009/tcp open ajp13
8080/tcp open http-proxy
Nmap finished: 1 IP address (1 host up) scanned in 1.845 seconds.
and when i'm entering:-
# nmap 192.168.1.110 -p T:5432
Starting Nmap 4.11 (
http://www.insecure.org/nmap/ ) at 2007-06-22 12:11 IST
Interesting ports on 192.168.1.110:
PORT STATE SERVICE
5432/tcp closed postgres
Nmap finished: 1 IP address (1 host up) scanned in 0.119 seconds
please help.