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

From Cornelia Boenigk
Subject Problem to connect to the Windows Port
Date
Msg-id 000901c486b5$07ebe840$0201a8c0@zwerg2000
Whole thread Raw
List 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@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?

Any help is appreciated.

Regards
Conni


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: mihai11@mailcity.com (Razvan)
Date:
Subject: Re: Postgres and JBOSS