Re: Problem to connect to the Windows Port

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Cornelia Boenigk" <c(at)cornelia-boenigk(dot)de>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem to connect to the Windows Port
Date: 2004-08-24 19:18:04
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE475B17@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Hello everybody
>
>I have installed the Windows-Port on a the machine 'mini' in the local
>network.
>In postgresql.conf on mini listen_adresses is set to '*'
>When trying to connect to this installation from the machine 'mach1' I
>get the following error:
>
>conni(at)mach1 ~
>$ psql -h mini -U postgres -d minitest
>psql: could not connect to server: Connection refused
> Is the server running on host "mini" and accepting
> TCP/IP connections on port 5432?
>
>I shut down the database server on mini and restarted it with the
>option -i.
>
>Then the error looks like this:
>
>conni(at)mach1 ~
>$ psql -h mini -U postgres -d minitest
>psql: FATAL: no pg_hba.conf entry for host "192.168.1.2", user
>"postgres", data
>base "minitest"
>
>All these errormessages appear on both machines.
>
>The IP for mach1 is 192.168.1.2
>The pg_hba.conf on mini contains the entries:
>
>host all all 192.168.1.2
>192.168.255.255 password
>host template1 postgres 192.168.1.2 192.168.255.255
>password
>host minitest postgres 192.168.1.2 192.168.255.255
>password
>
>Do I miss something?

The pg_hba lines should be:
host all all 192.168.1.2 255.255.255.255 password
host template1 postgres 192.168.1.2 255.255.255.255 password
host minitest postgres 192.168.1.2 255.255.255.255 password

192.168.255.255 is not a valid netmask. The mask above will match one
host. If you meant to match the entire subnet (192.168.*.*), instead put
host minitest postgres 192.168.0.0 255.255.0.0 password

//Magnus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-08-24 19:20:11 Re: UTF-8 and LIKE vs =
Previous Message Tom Lane 2004-08-24 19:16:00 Re: [NOVICE] Authentication problems