Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 48ED89FA4EE
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 11 Jan 2007 06:53:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 56692-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 11 Jan 2007 06:53:30 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk
 [80.175.28.46])
	by postgresql.org (Postfix) with ESMTP id 98E509FA435
	for <pgsql-admin@postgresql.org>; Thu, 11 Jan 2007 06:53:30 -0400 (AST)
Received: from [213.146.139.35] (port=57291 helo=[172.21.18.250])
	by perth.mailnetwork.co.uk with esmtpa (Exim 4.63)
	(envelope-from <andy.shellam-lists@mailnetwork.co.uk>)
	id 1H4xYn-0001rc-Gz; Thu, 11 Jan 2007 10:53:29 +0000
Message-ID: <45A61751.6040603@mailnetwork.co.uk>
Date: Thu, 11 Jan 2007 10:54:09 +0000
From: "Andy Shellam (Mailing Lists)" <andy.shellam-lists@mailnetwork.co.uk>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: Josef Springer <Josef.Springer@joops.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
References: <450FAE7A.9070408@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C6@algol.sollentuna.se>
	<450FC3E0.2030001@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se>
	<45A60D3E.1060700@joops.com>
In-Reply-To: <45A60D3E.1060700@joops.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/95
X-Sequence-Number: 24251

Firstly it would be helpful to say what error you're getting on the 
client side.
At a quick guess, I would say it's because you've got 2 "0.0.0.0" 
declarations in your pg_hba.conf - you only need the one - like this:

host    all     all     0.0.0.0/0       md5

Regards,

Andy.

Josef Springer wrote:
> Hi folks,
>
> i have a workgroup (not a classic server)  with Windows-XP-machines:
>
> the database server machine contains the line
> host            all            all            0.0.0.0        
> 0.0.0.0    md5
> in the file pg_hba.conf
> and
> listen_addresses = '*' 
> in the file postgresql.conf.
>
> the 'client's host file contain the line
> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress of 
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to 
> the database on the /Labor/ no matter wether i use the machine's name 
> or the IP-adress.
>
> What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> Postal
> 	Address
> 	_Josef.Springer@joops.com _
> 	Orlando-di-Lasso Str. 2
> 	D-85640 Putzbrunn
> Phone
> 	Office
> 	+49 (0)89 600 6920
> 	
> 	
> Phone
> 	Fax
> 	+49 (0)89 600 69220
> 	
> 	
> Web
> 	Web
> 	http://www.joops.com
> 	
> 	
>
>
> JOOPS
> 	*-- the software company --*
>
>
>  
>
>
> !DSPAM:37,45a60e36137102078430163! 


-- 
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834