From: | donghe(at)caltech(dot)edu |
---|---|
To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: PHP cann't access to postgres databse |
Date: | 2009-06-26 17:24:23 |
Message-ID: | 2209.131.215.15.78.1246037063.squirrel@webmail.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)caltech(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Carol Walter | 2009-06-26 17:24:34 | Re: PHP cann't access to postgres databse |
Previous Message | Kevin Grittner | 2009-06-26 17:07:11 | Re: PHP cann't access to postgres databse |