Re: psql: error: could not connect to server: Connection refused

BeeRich Lists <bee.lists@gmail.com> writes:
> It worked!  It was the firewall that needed a port hole poked in it.

Huh, interesting.  What I'd have expected from a firewall problem
is that the postmaster thinks it's listening on the port (and says
so at startup), but then no traffic actually reaches it.  The fact
that you didn't see any log entry about "listening on IPv4 address
so-and-so" suggests that your machine's version of a firewall is
interfering with even binding to the address.  Not impossible
I guess, but it's a new one on me.

            regards, tom lane