Re: Cannot connect remotely to postgresql

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@iol.ie