X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F18BA475C98 for ; Sun, 30 Mar 2003 21:15:58 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 10259475A71 for ; Sun, 30 Mar 2003 21:15:57 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2V2FSub013584; Sun, 30 Mar 2003 21:15:28 -0500 (EST) To: "dailiming" Cc: "Peter Eisentraut" , "Bruno Wolff III" , "Rudi Starcevic" , pgsql-sql@postgresql.org Subject: Re: How to configure two netcard for PostgreSQL? In-reply-to: <009e01c2f720$febdc920$1f00a8c0@accunettech.com> References: <009e01c2f720$febdc920$1f00a8c0@accunettech.com> Comments: In-reply-to "dailiming" message dated "Mon, 31 Mar 2003 09:00:53 +0800" Date: Sun, 30 Mar 2003 21:15:28 -0500 Message-ID: <13583.1049076928@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, 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/653 X-Sequence-Number: 12691 "dailiming" writes: > Yes, I have already set the two Ip address in the pg_hba.conf file . > But It do nothing. No, what you need is to put in the addresses or address ranges of all the machines that will connect through either net card. (And don't forget to SIGHUP the postmaster after you change its config file.) The fact that there are multiple net cards doesn't matter at all; Postgres should bind to its port number on each of the machine's IP addresses, automatically. regards, tom lane