Cannot connect remotely to postgresql
От | Willem Buitendyk |
---|---|
Тема | Cannot connect remotely to postgresql |
Дата | |
Msg-id | ECADCFD0-A069-448B-BBBB-A50FDB6ABB21@pcfish.ca обсуждение исходный текст |
Ответы |
Re: Cannot connect remotely to postgresql
|
Список | 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.confsuch 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 amstill able to connect the server using "psql -h localhost -U postgres -d xxx" I am assuming (perhaps incorrectly) thatI shouldn't be able to do this. So now I'm completely stumped. I've searched my computer and can't find any other conffiles. I recently set $PGDATA to "C:\Program Files (x86)\PostgreSQL\8.3\data\" and the same in my $PATH for bin. Ido notice that lib is not installed in my $PATH but assume that would not affect my connection. Any ideas?
В списке pgsql-general по дате отправления: