On Friday, September 30, 2011 3:17:51 am Pietro Laranci wrote:
> Good morning to everybody
>
> I have a pg9 db to wich i can connect to by local but not from remote. In
> the properties of the postgres db , the port is set to 5300 (not the
> default 5432). I tried to connect in remote with pgadmin3 and quantum gis,
> both give the error Connection refused (0x0000274D/10061). This is the
> complet message in quantum gis (but is silimar in pgadmin3)
>
> "could not connect to server: Connection refused (0x0000274D/10061)
>
> Is the server running on host "95.110.201.74" and accepting
>
> TCP/IP connections on port 5300?"
>
>
>
> Whit both the programs installed on the same pc of the db, i can connect
> without problem to the db.
>
>
>
> I already did these settings:
>
>
>
> - in postgresql.conf : listen_addresses = '*' and port = 5300 (in the place
> of the default 5432)
>
>
>
> - in pg_hba.conf:
>
> host [dbname] all 0.0.0.0/0 md5
>
> host [dbname] all 127.0.0.1/32 md5
>
>
>
> - restarted postgres
>
>
>
>
>
> I also tried to substitute on the db properties "host=localhost" with
> "host=95.110.201.74"
>
>
>
> On the machines are not active firewalls.
>
>
>
> Have you any clue of what's wrong?
You did not say what OS you are running Postgres on, at a guess I am going to go
with Windows. Are you sure the Windows firewall is not blocking port 5300?
>
>
>
> Grazie
>
>
>
> Thanks
--
Adrian Klaver
adrian.klaver@gmail.com
