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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
>Hello everybody
>I have installed the Windows-Port on a the machine 'mini' in the local
>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 "", user
>"postgres", data
>base "minitest"
>All these errormessages appear on both machines.
>The IP for mach1 is
>The pg_hba.conf on mini contains the entries:
>host    all               all      
>   password
>host    template1    postgres
>host    minitest       postgres
>Do I miss something?

The pg_hba lines should be:
host all all password
host template1 postgres password
host minitest postgres password 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 password



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-2018 The PostgreSQL Global Development Group