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@caltech.edu> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
