First of all, great to see some activity in the area. :)
On Tue, 2011-05-10 at 17:50 -0400, Joe wrote:
> I have installed PostgreSQL, along with PostGIS, on my system. However,
> whenever I try to connect to the PostgreSQL Server, not running as a
> localhost, I get the message:
> could not connect to server: Connection refused (0x0000274D/10061) Is
> the server running on host "192.168.1.13" and accepting TCP/IP
> connections on port 5432?
This sounds like Postgres is either not running, or there's a firewall
on your server that's actively rejecting connections on the port.
I would guess the former, as I'd assume a firewall would always block
connections on port 5432 and you'd never see the next error message, but
it's still a possibility.
> FATAL: no pg_hba.conf entry for host "192.168.1.8", user "postgres",
> database "postgres", SSL off
Have you made any changes to your pg_hba.conf file? It sounds like
there's just not an entry in it for the local network. You'll likely
want to drop a line into the file that looks similar to:
# Connections from the local LAN
host all all 192.168.1.0/24 md5
... assuming you want to allow connections from that address range,
adjust as necessary.
Trigger a reload or restart of Postgres, and that should let you in.
What version of Postgres are you running? And in what environment?
In response to
spug by date
|Next:||From: Joe||Date: 2011-05-11 17:18:07|
|Subject: Re: Installation questions|
|Previous:||From: Joe||Date: 2011-05-10 21:50:03|
|Subject: Installation questions|