X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 17931476472
	for <pgsql-sql@postgresql.org>; Mon, 31 Mar 2003 10:40:39 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 47ED0476393
	for <pgsql-sql@postgresql.org>; Sun, 30 Mar 2003 23:42:17 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h2V4fl2L016249;
	Sun, 30 Mar 2003 23:41:47 -0500 (EST)
To: "dailiming" <ldai@accunettech.com>
Cc: "Peter Eisentraut" <peter_e@gmx.net>, "Bruno Wolff III" <bruno@wolff.to>,
	"Rudi Starcevic" <rudi@oasis.net.au>, pgsql-sql@postgresql.org
Subject: Re: How to configure two netcard for PostgreSQL? 
In-reply-to: <00b901c2f730$5e9996d0$1f00a8c0@accunettech.com> 
References: <Pine.LNX.4.44.0303281446470.2204-100000@peter.localdomain>
	<009e01c2f720$febdc920$1f00a8c0@accunettech.com>
	<13583.1049076928@sss.pgh.pa.us>
	<00b901c2f730$5e9996d0$1f00a8c0@accunettech.com>
Comments: In-reply-to "dailiming" <ldai@accunettech.com>
	message dated "Mon, 31 Mar 2003 10:51:03 +0800"
Date: Sun, 30 Mar 2003 23:41:47 -0500
Message-ID: <16248.1049085707@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-29.3 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200303/656
X-Sequence-Number: 12694

"dailiming" <ldai@accunettech.com> writes:
> host all 192.168.0.10 255.255.255.0 trust
> host all 192.168.1.10 255.255.255.0 trust

Nonzeroes in the address where there are zeroes in the mask is a loser.
Try

host all 192.168.0.0 255.255.255.0 trust
host all 192.168.1.0 255.255.255.0 trust

Of course, you could replace both of these lines with

host all 192.168.0.0 255.255.254.0 trust

			regards, tom lane