From rhunter@enterasys.com Thu Feb 14 21:03:22 2002 Received: from ctron-dnm.ctron.com (ctron-dnm.enterasys.com [12.25.1.120]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1EL3ME77774 for ; Thu, 14 Feb 2002 16:03:22 -0500 (EST) (envelope-from rhunter@enterasys.com) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id QAA01078 for ; Thu, 14 Feb 2002 16:12:50 -0500 (EST) Received: from unknown(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma000979; Thu, 14 Feb 02 16:12:39 -0500 Received: by cnc-exc1.enterasys.com with Internet Mail Service (5.5.2653.19) id <1VYXPGKG>; Thu, 14 Feb 2002 16:02:10 -0500 Message-ID: <59358A738F45D51186A30008C74CE250E813A5@slc-exc1.ctron.com> From: "Hunter, Ray" To: pgsql-sql@postgresql.org Subject: Front and Back End Date: Thu, 14 Feb 2002 16:02:26 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1B59A.E7C430B0" X-Archive-Number: 200202/161 X-Sequence-Number: 6587 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C1B59A.E7C430B0 Content-Type: text/plain I am wondering if anyone has suggestions and comments on setting up an intranet site with a Postgres backend database. I have 4 high end servers that I will be using in this configuration. 2 will be web server (production), 1 database server, and 1 backup server. I am curious how individuals might go about setting this up for load balancing on the web servers and optimizing the backend database. If you have any comment, suggestions, warnings, etc.; I would be more than thankful to hear them. Thanks, Ray Hunter Firmware Engineer ENTERASYS NETWORKS Phone: 801 887-9888 Fax: 801 972-5789 Email: rhunter@enterasys.com www: www.enterasys.com ------_=_NextPart_001_01C1B59A.E7C430B0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Front and Back End

I am wondering if anyo= ne has suggestions and comments on setting up an intranet site with a Postg= res backend database.  I have 4 high end servers that I will be using = in this configuration.  2 will be web server (production), 1 database = server, and 1 backup server.  I am curious how individuals might go ab= out setting this up for load balancing on the web servers and optimizing th= e backend database.

If you have any commen= t, suggestions, warnings, etc.; I would be more than thankful to hear them.=


Thanks,


Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS

Phone:      &nb= sp;   801 887-9888
Fax:      &nbs= p;     801 972-5789
Email:      &n= bsp;   rhunter@enterasys.com=
www:      &nbs= p;     <= FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Verdana">www.enterasys.com

------_=_NextPart_001_01C1B59A.E7C430B0-- From josh@agliodbs.com Thu Feb 14 21:33:31 2002 Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1ELXUE82437 for ; Thu, 14 Feb 2002 16:33:31 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 694346; Thu, 14 Feb 2002 13:33:30 -0800 From: "Josh Berkus" Subject: Re: Front and Back End To: "Hunter, Ray" , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Thu, 14 Feb 2002 13:33:30 -0800 Message-ID: In-Reply-To: <59358A738F45D51186A30008C74CE250E813A5@slc-exc1.ctron.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/163 X-Sequence-Number: 6589 Ray, > I am wondering if anyone has suggestions and comments on setting up > an > intranet site with a Postgres backend database. I have 4 high end > servers > that I will be using in this configuration. 2 will be web server > (production), 1 database server, and 1 backup server. I am curious > how > individuals might go about setting this up for load balancing on the > web > servers and optimizing the backend database. This is not the right list for this question. Try pgsql-php (if you're using php) or pgsql-jdbc (if you're using Java), or pgsql-odbc (if you're on Microsoft). -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco From chriskl@familyhealth.com.au Fri Feb 15 01:23:15 2002 Received: from mail.iinet.net.au (symphony-06.iinet.net.au [203.59.3.38]) by postgresql.org (8.11.3/8.11.4) with SMTP id g1F1NFE20847 for ; Thu, 14 Feb 2002 20:23:15 -0500 (EST) (envelope-from chriskl@familyhealth.com.au) Received: (qmail 30098 invoked by uid 666); 15 Feb 2002 01:23:11 -0000 Received: from unknown (HELO houston.familyhealth.com.au) (203.59.231.6) by mail.iinet.net.au with SMTP; 15 Feb 2002 01:23:11 -0000 Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6/8.11.6) id g1F1NC338474 for pgsql-php@postgresql.org; Fri, 15 Feb 2002 09:23:12 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6/8.9.3) with SMTP id g1F1NBX38377; Fri, 15 Feb 2002 09:23:11 +0800 (WST) From: "Christopher Kings-Lynne" To: "Hunter, Ray" , Subject: Re: [SQL] Front and Back End Date: Fri, 15 Feb 2002 09:24:48 +0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal In-Reply-To: <59358A738F45D51186A30008C74CE250E813A5@slc-exc1.ctron.com> X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Archive-Number: 200202/45 X-Sequence-Number: 951 (Reposted to pgsql-php) Hi Ray, Setting up load balancing on the web servers is probably up to you, but please tell us what type of machine the database server will be: BSD, Linux, Solaris, Win2K, etc. and we can probably give you lots of performance tips. Chris -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Hunter, Ray Sent: Friday, 15 February 2002 5:02 AM To: pgsql-sql@postgresql.org Subject: [SQL] Front and Back End I am wondering if anyone has suggestions and comments on setting up an intranet site with a Postgres backend database. I have 4 high end servers that I will be using in this configuration. 2 will be web server (production), 1 database server, and 1 backup server. I am curious how individuals might go about setting this up for load balancing on the web servers and optimizing the backend database. If you have any comment, suggestions, warnings, etc.; I would be more than thankful to hear them. Thanks, Ray Hunter Firmware Engineer ENTERASYS NETWORKS Phone: 801 887-9888 Fax: 801 972-5789 Email: rhunter@enterasys.com www: www.enterasys.com