Page 1 of 1

Postgres only visible at IP 127.0.0.1

PostPosted: Fri Mar 21, 2008 6:47 pm
by brownalan
I can't telnet to my postgres port at anything other than 127.0.0.1 5432

I can access my db locally only when I use localhost or 127.0.0.1 as the address.

my internal ip address (10.0.1.45) doesn't work (from itself or from another machine). Is this a postgres setting I need to change or is this a windows issue? So I can't access my db from any machine apart from the one it's running on.

Any help would be much appreciated.

Re: Postgres only visible at IP 127.0.0.1

PostPosted: Fri Mar 21, 2008 7:04 pm
by _dave_
yeah, it is in the pg_hba.conf file, right at the bottom.

You need to allow access for your individual computers (or as I lazily do, whole range).

should be obvious enough when you look at he file (for someone who is using telnet and talking about IP addresses anyhow :) ) - but post if you need more instruction.

EDIT: of course make sure some local firewall isn't preventing incoming connections on 5432, and I think you have to restart the postgres service after editing pg_hba.conf too.