Re: Problem to connect to the Windows Port - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Problem to connect to the Windows Port
Date
Msg-id 412C5897.3050804@bigfoot.com
Whole thread Raw
In response to Re: Problem to connect to the Windows Port  ("Cornelia Boenigk" <poppcorn@cornelia-boenigk.de>)
Responses Question about SQL statement error
List pgsql-general
Cornelia Boenigk wrote:

> Hi Magnus
>
> Thanks.
>
>
>>If you meant to match the entire subnet (192.168.*.*), instead put
>>host minitest postgres 192.168.0.0 255.255.0.0 password
>
>
> Ok. I changed the line in pg_hba.conf to
>
> host all all 192.168.0.0  255.255.0.0 password
>
> then rebooted the computer and tried again:
>
> C:\>psql -h 192.168.1.8 -U postgres -d minitest
> psql: could not connect to server: Connection refused
>         Is the server running on host "192.168.1.8" and accepting
>         TCP/IP connections on port 5432?
>
> The server on 192.168.1.8 is running, (I can connect on this machine
> to localhost/minitest.).
> I can ping 192.168.1.8

I could you execute on your server the following command:

netstat -an and look for the row that say LISTENING on port 5432 ?


Regards
Gaetano Mendola










pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Missing FROM clause
Next
From: Mário Gamito
Date:
Subject: Question about SQL statement error