[SunHELP] Opening port 5432 for PostgreSQL

Will McDonald wmcdonald at gmail.com
Tue Jan 24 04:25:46 CST 2006

On 23/01/06, Micah DesJardins <micahdj at gmail.com> wrote:
> Locally, I can connect to the database using the built in client
> (psql) just fine, but I can't do the same from my Mac OS X machine on
> the same subnet.

Check your pg_hba.conf [1] and postgresql.conf [2] in $PGDATA.

It's probably configured to only accept local socket connections or to
only listen on the loopback.

Upping the logging in postgresql.conf and checking the logs will help too.



[2] http://www.postgresql.org/docs/8.1/interactive/runtime-config.html

More information about the SunHELP mailing list