--- On Fri, 12/12/08, Bastiaan Olij <lists(at)basenlily(dot)nl> wrote:
> If you are on Mac or
> Linux, are
> the privileges set correctly? On one of our Mac servers we
> it took us
> some time to figure out Postgres was simply ignoring the
> files because
> the privileges where set different then it wanted, even
> though it did
> seem to have access.
I think the problem is something along these lines. I originally had the authentication method set to "MD5" in pg_hba.conf. I changed it to "trust" (and restarted postgres) just to try to get it working, without success. I happened to reboot the postgres host (linux) and httpd wouldn't start because it couldn't find mod_auth_pgsql.so. I commented out the line in auth_pgsql.conf loading it and apache complained that it needed the ssl passphrase.
I have mod_auth_pgsql.so so I'm going to try to mollify apache with that and see where it leads.
As for Tom's suggestion that the firewall is the problem, I don't think it is, having looked at the IPTables rules. There are essentially no restrictions (the network is behind a firewall). Having said that, I don't know much about IPTables and there were 1 or 2 entries that I definitely didn't understand. I plan to learn IPTables too though.
Thanks for the help,
> Bruce Hyatt wrote:
> > I've been over my pg_hba.conf and postgresql.conf
> files again and again, restarting after changes and I always
> get 08004 connection refused when I try to connect through
> the postgresql jdbc from another machine.
> > The user name I'm using works from the postgresql
> host and I have enabled IP/TCP connections to the database.
> > Anything else? Surely this is something obvious
> I'm overlooking.
> > Thanks,
> > Bruce Hyatt
pgsql-novice by date
|Next:||From: Wright, George||Date: 2008-12-16 14:18:52|
|Subject: strange looking error|
|Previous:||From: Tom Lane||Date: 2008-12-13 04:41:30|
|Subject: Re: connection refused |