I tried manually starting without the service automatically running using pg_ctl start -D "c:\program files (x86)\etc etc" which reported back that i might have another postmaster running. I then did pg_ctl reload -D "c:\program files (x86)\etc etc" and it sent a signal and voila it worked. I have since put everything back to having the postgresql service start automatically upon machine startup and its back to not working. In fact, when I run pg_ctl status from a fresh boot with the postgresql service automatically starting I get the return message of: pg_ctl: no server running. So perhaps there is something with 8.3 and windows 64 specifically in that the configuration files are loading from somewhere else. Very peculiar behaviour. I have some resolve from my madness. At least I can manually start the service and have it running properly. 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? > > 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
