Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id EE91D2E003D for ; Sun, 15 Jun 2008 14:27:42 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36815-05 for ; Sun, 15 Jun 2008 14:27:39 -0300 (ADT) X-Greylist: delayed 00:16:17.273248 by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.234]) by developer.postgresql.org (Postfix) with ESMTP id 3C9D42E003C for ; Sun, 15 Jun 2008 14:27:40 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id a16so1849082qbd.23 for ; Sun, 15 Jun 2008 10:27:39 -0700 (PDT) Received: by 10.142.126.17 with SMTP id y17mr1989345wfc.300.1213549878933; Sun, 15 Jun 2008 10:11:18 -0700 (PDT) Received: by 10.142.78.7 with HTTP; Sun, 15 Jun 2008 10:11:18 -0700 (PDT) Message-ID: <72fa1b080806151011h357edc5bm92af30e08aeefd61@mail.gmail.com> Date: Sun, 15 Jun 2008 12:11:18 -0500 From: "Andreas Philipp" To: pgsql-admin@postgresql.org Subject: Advice on running two database clusters on one server machine MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/119 X-Sequence-Number: 29457 Hi all, We are implementing a hospital information system and a human resources/payroll processing system on two identical dedicated servers with two Xeon Quad Core processors and 32 GB RAM each, both servers being attach= ed via FC to a SAN, and both applications running on PostgreSQL 8.3 / CentOS 5= 1. We are wondering about the advisability to distribute the databases between the two server machines, both machines acting as active production systems for one application each, and as warm standby servers for the other, using WAL shipping to a second database cluster running on another port on each o= f the two server machines. What would be the performance cost of doing so, rather than running all databases on one database cluster on one machine, and using the second machine as a warm standby server for all databases of the two applications? What other considerations should we take into account? We have no prior experience with PostgeSQL administration, having run our previous systems o= n Windows Servers and MS SQL Server. Thanks to all for your input! -- Andreas Philipp Cl=EDnica Universitaria Telet=F3n Ch=EDa, Colombia