From: Tom Lane <tgl@sss.pgh.pa.us>
To: Anuj Pankaj <anujp@cybage.com>
Cc: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: could not connect to server: Connection refused (0x0000274D/10061)
Date: Fri, 01 Oct 2010 09:13:57 -0400
Message-ID: <25917.1285938837@sss.pgh.pa.us> (raw)
In-Reply-To: <2856B55CBB911B488D04E177EEF57D3311B4FC5B@ct-beexch-1-1.cybage.com>
References: <2856B55CBB911B488D04E177EEF57D3311A1504D@ct-beexch-1-1.cybage.com>
<F4C27E77F7A33E4CA98C19A9DC6722A20690D33C@EXCHANGE.corp.perceptron.com>
<2856B55CBB911B488D04E177EEF57D3311B4FC5B@ct-beexch-1-1.cybage.com>
Anuj Pankaj <anujp@cybage.com> writes:
> What am I suppose to change in pg_hba.conf file?
If you're getting "Connection refused", no amount of changing
pg_hba.conf will change the result, because that's not where your
problem is. This error implies the postmaster isn't listening at all on
the specified port, or else there's a firewall blocking connections.
Make sure that listen_addresses is set to * in postgresql.conf, and
check your system packet-filtering configuration.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, anujp@cybage.com, ineyman@perceptron.com
Subject: Re: could not connect to server: Connection refused (0x0000274D/10061)
In-Reply-To: <25917.1285938837@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox