>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@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@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