Re: Cannot connect to remote postgres using php - Mailing list pgsql-php

From Dimitris Sakellarios
Subject Re: Cannot connect to remote postgres using php
Date
Msg-id 78A8EE7180F64BB9B80731343DC27C2D@toshiba
Whole thread Raw
In response to Cannot connect to remote postgres using php  (Archana K N <archanakknn@gmail.com>)
List pgsql-php

Dear Archana hi,

 

Follow below:

 

Step0

Make sure you have no firewall between you (php server root ip) and the server that blocks requests.

 

If this is OK then:

 

Step1   

Inside postgresql.conf make sure you have set the listen IP and listen port of your server and this will be the port you connect with php pg_connect

 

Step2

Inside pg_hda.conf configure the hosts you will allow connection either as trusted or md5

 

Typically bellow will allow all to connect

 

hostnossl    all         all         0.0.0.0/0          trust

 

Below will allow all to connect using username and password (but before have the first rule enabled to create remotely the users)

 

hostnossl    all         all         0.0.0.0/0          md5

 

Step3    restart Pgsql server to grand the new setting.

 

BR,

 

 

Sakellarios Dimitris

Telesuite ltd Telecommunication and Internet Services

Address : T. Sofouli 14, Post Code 16344, Ilioupoli - Athens, Greece

T.: +30 211 760 1300 F.: +30 211 176 9999 M.: +30 6982 550 850 e-mail: dimitris.sakellarios@telesuite.gr  url: http://www.telesuite.gr


From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Archana K N
Sent: Monday, April 30, 2012 11:30 AM
To: pgsql-php@postgresql.org
Subject: [PHP] Cannot connect to remote postgres using php

 


Hello,

       I am getting this error whenever I try to connect to remote computer.
"Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "10.162.19.3" and accepting TCP/IP connections on port 5432?  "
--
-------------------
regards
archana
--------------------

pgsql-php by date:

Previous
From: Narongdetch Jongjit
Date:
Subject: Re: Cannot connect to remote postgres using php
Next
From: Sven Marcel Buchholz
Date:
Subject: Re: Cannot connect to remote postgres using php