X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3AC5947637B
	for <pgsql-sql@postgresql.org>; Mon, 31 Mar 2003 10:42:58 -0500 (EST)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id 520F74763F5
	for <pgsql-sql@postgresql.org>; Mon, 31 Mar 2003 01:35:07 -0500 (EST)
Received: from klaster.net (pa128.krakow.cvx.ppp.tpnet.pl [213.76.36.128])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id D543C6A277; Mon, 31 Mar 2003 08:29:49 +0200 (CEST)
Message-ID: <3E87E084.8070302@klaster.net>
Date: Mon, 31 Mar 2003 08:30:28 +0200
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
 rv:1.3) Gecko/20030312
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: dailiming <ldai@accunettech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to configure two netcard for PostgreSQL?
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>
In-Reply-To: <00b901c2f730$5e9996d0$1f00a8c0@accunettech.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-31.1 required=5.0
	tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,RCVD_IN_RFCI,
	REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA
	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/657
X-Sequence-Number: 12695

Uz.ytkownik dailiming napisa?:
> I try again. 
> F.E:
> First,I modified the pg_hba.conf cfg file.
> 
> host all 192.168.0.10 255.255.255.0 trust
> host all 192.168.1.10 255.255.255.0 trust
> 
> Second, I used "/etc/rc.d/init.d/postgresql" to stopping the postmaster.
> Finally, I restart the postmaster by "/usr/bin/postmaster -i -S -D /var/lib/pgsql/lib/data".
> 
> When I telnet 192.168.0.10 to connect database,I have the same results as before.
> 
> "psql -h 192.168.0.10 coredb  " is failed.
> "psql -h 192.168.1.10 coredb "  is successed.
> 
> Why the first is failed?


I have postgres 7.3. I tested your case on ip-alias on only one netcard
and it works fine.
Maybe you have some routing problems? Can you ping both netcards?

Regards,
Tomasz Myrta