Re: Cannot connect remotely to postgresql

From: Willem Buitendyk <willem(at)pcfish(dot)ca>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot connect remotely to postgresql
Date: 2012-01-19 20:40:33
Message-ID: DBFE1086-6F22-41D3-B6A1-8B8BE79483B0@pcfish.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2012-01-19 20:52:00 Re: Cannot connect remotely to postgresql
Previous Message Raymond O'Donnell 2012-01-19 20:17:25 Re: schema question