Re: PHP cann't access to postgres databse

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux