Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connection refused (0x0000274D/10061)

Connection refused (0x0000274D/10061)

From
"Pietro Laranci"
Date:
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 = '*' e port = 5300 (in the place of the default 5432)

- in pg_hba.conf:  host   [dbname]   all     0.0.0.0/0      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.

 

Could you give me any clue?

 

Grazie

 

Pietro

 

*************************************************************
-  TERRASYSTEM Srl  -
Environmental Management,
Monitoring and Research
 
via Pacinotti, 5
01100 Viterbo
Tel/Fax  +390761-250626
info@terrasystem.it
www.terrasystem.it
*************************************************************
 
 

Re: Connection refused (0x0000274D/10061)

From
Carlo Ascani
Date:
On Wed, 28 Sep 2011 10:04:40 +0200
"Pietro Laranci" <p.laranci@terrasystem.it> 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)

What operating system are you running ?




--
 Carlo Ascani - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 carlo.ascani@2ndQuadrant.it - www.2ndQuadrant.it