| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | adrian(dot)klaver(at)gmail(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, "general_lee" <tim_stockford(at)hotmail(dot)com> |
| Subject: | Re: How to add hosts to pg_hba.conf and postgresql.conf? |
| Date: | 2011-03-15 17:01:02 |
| Message-ID: | 308.1300208462@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> writes:
> On Tuesday, March 15, 2011 8:50:34 am general_lee wrote:
>> But I get a "connection refused" if I try and telnet to port 5432 from a
>> remote host.
> Is this a "connection refused" from Postgres or telnet?
Postgres doesn't ever emit an error message spelled like that. This
error means the connection request is never getting to the postmaster,
which means either (a) the postmaster isn't actually running, or at
least isn't listening on the port you think it is, or (b) there's a
packet filter or something similar blocking the connection request from
getting through.
If you can connect locally but not remotely, then it's almost certainly
(b). Check network-related settings to see about opening up port 5432.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2011-03-15 17:11:15 | Re: How to add hosts to pg_hba.conf and postgresql.conf? |
| Previous Message | Adrian Klaver | 2011-03-15 16:44:18 | Re: PostgreSQL for Holdem Manager could not be installed. |