[SunHELP] Opening port 5432 for PostgreSQL

Micah DesJardins micahdj at gmail.com
Tue Jan 24 10:08:39 CST 2006


Thanks!

It was listening only on localhost! Not sure what I was thinking what
with not going through the conf like that.

Micah

On 1/24/06, Will McDonald <wmcdonald at gmail.com> wrote:
> 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
> _______________________________________________
> SunHELP maillist  -  SunHELP at sunhelp.org
> http://www.sunhelp.org/mailman/listinfo/sunhelp
>



More information about the SunHELP mailing list