X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B8B4932A0DD for ; Tue, 19 Oct 2004 18:00:24 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65200-03 for ; Tue, 19 Oct 2004 17:00:20 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id 90805329EB7 for ; Tue, 19 Oct 2004 18:00:19 +0100 (BST) Received: (qmail 58887 invoked by uid 0); 19 Oct 2004 17:00:18 -0000 Received: from mpls-pop-08.inet.qwest.net (63.231.195.8) by mpls-qmqp-04.inet.qwest.net with QMQP; 19 Oct 2004 17:00:18 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-08.inet.qwest.net with SMTP; 19 Oct 2004 17:00:18 -0000 Date: Tue, 19 Oct 2004 11:02:31 -0600 Message-Id: <1098205351.21035.33.camel@localhost.localdomain> From: "Scott Marlowe" To: "Kent Anderson" Cc: "Pgsql-Admin@Postgresql. Org" Subject: Re: NIC to NIC connection In-Reply-To: References: Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/237 X-Sequence-Number: 15230 This is more a networking issue than a PostgreSQL one. What you'll like want to do is to set up a nic in each box and use a "rolled" cable directly between them. Assign an IP to each machine like 10.0.0.1 and 10.0.0.2 and edit your route tables to make each machine use those IPs respectively to talk to each other. I'm a unix guy, so explaining exactly how to do this in windows is a mystery to me. I'm guessing windows because of the ASP you mention. The basic theory stays the same though. On Tue, 2004-10-19 at 10:05, Kent Anderson wrote: > We are upgrading our servers and have run into an interesting > situation. It has been proposed that we have a direct connection from > the web servers to the postgres server via extra NICs. Has anyone done > this before and how big a project would it be to alter ASP and Java > applications to make use of such a connection? > > Before we even waste time installing the NIC's I would like a sense of > how hard it is to get postgres to use that kind of a connection vs > over the Internet. We are looking to increase communication speed > between the web servers and database server as much as possible. > > Thanks > Kent Anderson