Connection refused (0x0000274D/10061)

From: "Pietro Laranci" <p(dot)laranci(at)terrasystem(dot)it>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Connection refused (0x0000274D/10061)
Date: 2011-09-28 08:04:40
Message-ID: 905A0E4B8638417D99DA7A41E894034E@Elaborazione1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)terrasystem(dot)it
www.terrasystem.it
*************************************************************

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Hiroshi Saito 2011-09-30 13:24:21 Re: PostgreSQL ANSI OBDC Installation
Previous Message Nomeneta Saili 2011-09-28 03:23:12 PostgreSQL ANSI OBDC Installation