From: | Willem Buitendyk <willem(at)pcfish(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Cannot connect remotely to postgresql |
Date: | 2012-01-19 17:27:41 |
Message-ID: | ECADCFD0-A069-448B-BBBB-A50FDB6ABB21@pcfish.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have 8.2 installed on 64bit windows 7. I have no problem making a local connection. However, when I make changes to pg_hba.conf such as add:
local all all trust
I still cannot connect through a VPN. On a hunch that my pg server was not using the config files in "C:\Program Files (x86)\PostgreSQL\8.3\data" I changed the port in postgresql.conf to 5433 and restarted the server. After doing this I am still able to connect the server using "psql -h localhost -U postgres -d xxx" I am assuming (perhaps incorrectly) that I shouldn't be able to do this. So now I'm completely stumped. I've searched my computer and can't find any other conf files. I recently set $PGDATA to "C:\Program Files (x86)\PostgreSQL\8.3\data\" and the same in my $PATH for bin. I do notice that lib is not installed in my $PATH but assume that would not affect my connection. Any ideas?
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2012-01-19 18:10:46 | Re: Cannot connect remotely to postgresql |
Previous Message | Florian Weimer | 2012-01-19 16:53:14 | Re: On duplicate ignore |