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 D257032A35F for ; Tue, 19 Oct 2004 17:37:54 +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 57124-07 for ; Tue, 19 Oct 2004 16:37:47 +0000 (GMT) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id DC1F732A17C for ; Tue, 19 Oct 2004 17:37:45 +0100 (BST) Received: from solent (unknown [213.165.136.10]) by bayswater1.ymogen.net (Postfix) with ESMTP id 1B2A8A2D51; Tue, 19 Oct 2004 17:37:43 +0100 (BST) Reply-To: From: "Matt Clark" To: "'Kent Anderson'" , "'Pgsql-Admin@Postgresql. Org'" Subject: Re: NIC to NIC connection Date: Tue, 19 Oct 2004 17:37:43 +0100 Organization: Ymogen Ltd Message-ID: <00d001c4b5f9$f4d63660$8300a8c0@solent> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00D1_01C4B602.569A9E60" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_FONTCOLOR_BLUE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200410/235 X-Sequence-Number: 15228 This is a multi-part message in MIME format. ------=_NextPart_000_00D1_01C4B602.569A9E60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You would assign a different subnet to the connection, and then tell the servers to connect to the PG server's address on that subnet. No other changes required. Very odd setup though. If you want a 'private' connection then use a switch, rather than needing umpty NICs in the PG server. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Kent Anderson Sent: 19 October 2004 17:05 To: Pgsql-Admin@Postgresql. Org Subject: [ADMIN] NIC to NIC connection 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? =20 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.=20 =20 Thanks Kent Anderson ------=_NextPart_000_00D1_01C4B602.569A9E60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
You=20 would assign a different subnet to the connection, and then tell the server= s to=20 connect to the PG server's address on that subnet.  No other changes= =20 required.  Very odd setup though.  If you want a 'private' connec= tion=20 then use a switch, rather than needing umpty NICs in the PG=20 server.
-----Original Message-----
From:=20 pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org= ]=20 On Behalf Of Kent Anderson
Sent: 19 October 2004=20 17:05
To: Pgsql-Admin@Postgresql. Org
Subject: [ADMIN= ] NIC=20 to NIC connection

We are = upgrading=20 our servers and have run into an interesting situation.  It has been= =20 proposed that we have a direct connection from the web servers to=20 the postgres server via extra NICs. Has anyone done this before and = how=20 big a project would it be to alter ASP and Java applications to make use = of=20 such a connection?
 
Before = we even=20 waste time installing the NIC's I would like a sense of how hard it is to= get=20 postgres to use that kind of a connection vs over the Internet. We are lo= oking=20 to increase communication speed between the web servers and database= =20 server as much as possible.
 
Thanks
Kent= =20 Anderson
------=_NextPart_000_00D1_01C4B602.569A9E60--