On 2012-01-19, at 10:10 AM, Raymond O'Donnell wrote: > On 19/01/2012 17:27, Willem Buitendyk wrote: >> 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 > > What is the exact error message you're getting? > > Did you restart the server after changing pg_hba.conf? > > Also, I don't think "local" rules do anything on windows - you need to > add a "host" rule as the connections are over TCP/IP (though I could be > wrong). > >> 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. > > That does seem odd - you should need the -p option for anything other > than the standard port. > > Is there any chance that you have more than one installation running on > the machine, and the other one is listening on port 5432? There is only one service listed. If I try the following: C:\Users\Willem>postgres -D "C:\Program Files (x86)\PostgreSQL\8.3\data" I get: 2012-01-19 10:48:06 PST LOG: loaded library "$libdir/plugins/plugin_debugger.dl l" 2012-01-19 10:48:06 PST LOG: could not bind IPv4 socket: No error 2012-01-19 10:48:06 PST HINT: Is another postmaster already running on port 543 3? If not, wait a few seconds and retry. 2012-01-19 10:48:06 PST WARNING: could not create listen socket for "10.0.1.7" There appears to be no other instance of postgresql running on my system other then the one. I will try a restart without the service starting automatically and try a manual start next. > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
