Re: Cannot connect to remote postgres using php

From: "Dimitris Sakellarios" <dimitris(dot)sakellarios(at)telesuite(dot)gr>
To: "'Archana K N'" <archanakknn(at)gmail(dot)com>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: Cannot connect to remote postgres using php
Date: 2012-04-30 08:40:37
Message-ID: 78A8EE7180F64BB9B80731343DC27C2D@toshiba
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 <mailto:dimitris(dot)sakellarios(at)telesuite(dot)gr>
@telesuite.gr url: http://www.telesuite.gr <http://www.telesuite.gr/>

_____

From: pgsql-php-owner(at)postgresql(dot)org [mailto:pgsql-php-owner(at)postgresql(dot)org]
On Behalf Of Archana K N
Sent: Monday, April 30, 2012 11:30 AM
To: pgsql-php(at)postgresql(dot)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
--------------------

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Sven Marcel Buchholz 2012-04-30 08:43:53 Re: Cannot connect to remote postgres using php
Previous Message Hartmut Holzgraefe 2012-04-30 08:33:33 Re: Cannot connect to remote postgres using php