Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group