the default port 5432 is associated with postgres and localhost is connected # netstat -plunta | grep 5432 tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 3962/postgres tcp 0 0 ::1:5432 :::* LISTEN 3962/postgres # ping localhost PING localhost (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.037 ms 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.018 ms 64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.020 ms 64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.017 ms 64 bytes from localhost (127.0.0.1): icmp_seq=5 ttl=64 time=0.017 ms Dong > <donghe@xxxxxxxxxxx> wrote: > >> Is the server running on host "localhost" >> and accepting TCP/IP connections on port 5432? > > Is it? > > Depending on your platform, you can check which ports are accepting > connections with something like: > > netstat -plnt > > If you don't see your port open there, listening on all addresses or > on the localhost IP, you probably need to modify your postgresql.conf > file to set listen_addresses or port as you need them. (You will need > to restart PostgreSQL.) > > If the postgresql.conf file is good, you must have something > misconfigured in the networking on that box. You could run: > > ping localhost > > to see what that gives you. > > -Kevin > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
