Thread: Cannot connect to remote postgres using php

On 04/30/2012 10:30 AM, Archana K N wrote:
> 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?  "

there's most likely a firewall in between that drops packages ...

--
hartmut

On 30.04.12 10:30, Archana K N wrote:
>
> 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
> --------------------
Hello,

did your DB-Server accept connections via TCP/IP, can you connect via psql?

regards
Sven

On 30/04/2012 09:30, Archana K N wrote:
>
> 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?  "

Things to check:

- Is Postgres actually running on the server machine?

- Is it accepting TCP/IP connections on port 5432? - Check
listen_addresses in postgresql.conf

- Is there a firewall somewhere between client and server?

- Can you connect manually to the server using psql?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 30/04/2012 11:01, Archana K N wrote:
>
> Hello,
>
>  I can connect to the other computer using web browser and also can
> access postgres.

How exactly are you access Postgres? - psql, pgAdmin, or some other means?

Also, a *lot* more detail would help.... operating systems, Postgres
version, PHP version, whether you're connection on a LAN or over the
Internet, etc etc etc.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 30/04/2012 11:15, Archana K N wrote:
>
>
> I am using dreamweaver for creating web pages and requires php for
> connecting to server computerand database . Am also using pgadmin but
> can connect using that.
>
> Postgresql version-  9.
> Operating System- windows XP
> php version-5.2
> apache - 2.2
> and am using LAN

Hi Arachna,

[Please keep replies on-list; reply-all should do the job. Thanks!]

Is it possible that your Postgres server is listening on a different
port? If you can, could you post your postgresql.conf?

Also, are you maybe using a firewall locally on your Windows machine
which is blocking PHP?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 30.04.12 17:57, Archana K N wrote:
> My postgres server is listening to same port . I tried changing both
> but same error is showing.
>
> I restarted the servers after changing the conf files. pgadmin3 is
> running on both servers and i can connect them remotely. I am able to
> connect to local host using the php code.
>
> I think i have changed the files correctly , some antivirus softwares
> are running in the system i dont know whether that causes the problem.
>
>
> --
> -------------------
> regards
> archana
> --------------------
Hallo,

did yours server listens on other addresses than localhost (I mean the
parameter listen_addresses in your postgresql.conf)?

Kind regards

Sven

Hallo,

ok, do you use the same db-user for pgAdmin3 and your php-script? 

I host pgsql servers on both machines.

the pph code is like this

'

$conn=pg_connect("host=10.162.19.3 port=5432 dbname=postgres user=postgres password=postgresql");

'

--
-------------------
regards
archana
--------------------