From: | "Cornelia Boenigk" <c(at)cornelia-boenigk(dot)de> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Problem to connect to the Windows Port |
Date: | 2004-08-20 12:53:47 |
Message-ID: | 000901c486b5$07ebe840$0201a8c0@zwerg2000 |
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?
Any help is appreciated.
Regards
Conni
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-08-20 12:59:56 | Re: libpq: passwords WAS: scripting & psql issues |
Previous Message | Ulrich Wisser | 2004-08-20 12:52:37 | Adding missing FROM-clause entry for table "customer" |