Cannot connect remotely to postgresql

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?

Responses

Browse pgsql-general by date

  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