I have re started the computer (a few times) since I did all that.
Christine
At 09:08 AM 01/02/2010, you wrote:
On 02/01/2010 08:36 AM, Christine Penner wrote:
Hi,
I'm having trouble getting a connection to Postgres to work from outside
of my local network. It was working fine at one point. Then I had to
change IP addresses and I can't get it to work. This is what I've done.
On the computer with Postgres installed I have this in the pg_hba.conf
file:
host all all 207.6.93.152/32 md5
in the postgresql.conf file I have this:
listen_addresses = '*'
port = 5432
I also have the router set up to forward port 5432 to the computer with
Postgres installed.
I have confirmed that the IP address in pg_hba.conf and the IP address
being used to connect to are correct. I know the user name and password
etc are correct because I can connect locally using the same stuff. The
only things that have changed since it was working is IP addresses. I
confirmed they are right. Also when trying to get it working I noticed
that the port forwarding got disabled somehow so I set that up again but
still no luck.
I'm at a loss here. What else can I be missing?
Christine Penner
Ingenious Software
250-352-9495
christine@xxxxxxxxxxxxxxxxxxxxx
Did you have Postgres reload the file?:
pg_ctl reload
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
