[SunHELP] Opening port 5432 for PostgreSQL

[Will McDonald]

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.

Will.


[1]
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUT
H-PG-HBA-CONF

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