Re: Cannot connect to remote postgres using php

Hi,

When you changed the 2 files did you restart the Pgsql server? If not do it.

Where is the pgadmin3 installed on the same computer running the Pgsql
server or on a remote computer?

If it is on the same server default behaviour of Pgsql server is to allow
connection from the same server (local host) but if it is remotely then
either you will need to update the 2 files we mentioned earlier correctly.

Let me know.

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: Archana K N [mailto:archanakknn(at)gmail(dot)com]
Sent: Monday, April 30, 2012 1:20 PM
To: Dimitris Sakellarios
Subject: Re: [PHP] Cannot connect to remote postgres using php

hello,

I have changed both conf files. It is not working.

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

From: Archana K N [mailto:archanakknn(at)gmail(dot)com]
Sent: Monday, April 30, 2012 1:20 PM
To: Dimitris Sakellarios
Subject: Re: [PHP] Cannot connect to remote postgres using php

Yes my php script is running on a computer other than pgsql.

yes logged in as admin in pgsql.

I am using pgadmin 3 also. I can connect using pgadmin.

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

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
--------------------

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

listen_addresses is given as ' * ' . Didnt try it on other addresses.

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

Archana K N <archanakknn(at)gmail(dot)com> hat am 30. April 2012 um 18:16
geschrieben:

> listen_addresses is given as ' * ' . Didnt try it on other addresses.
>
>
> --
> -------------------
> regards
> archana
> --------------------

Hallo,

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