X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1EA24D8258 for ; Thu, 3 Nov 2005 09:49:41 -0400 (AST) 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 80694-01 for ; Thu, 3 Nov 2005 13:49:37 +0000 (GMT) Received: from www.3times25.net (unknown [198.212.166.252]) by svr1.postgresql.org (Postfix) with ESMTP id 6EE70D822D for ; Thu, 3 Nov 2005 09:49:39 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by www.3times25.net (Postfix) with ESMTP id 1015ADB9CB for ; Thu, 3 Nov 2005 08:49:43 -0500 (EST) Message-ID: <436A1576.7080300@3times25.net> Date: Thu, 03 Nov 2005 08:49:42 -0500 From: Geoffrey User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres-Admin list Subject: multiple postmasters on red hat cluster suite Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/23 X-Sequence-Number: 19396 We are going to use the red hat cluster suite for a database solution and would like to know if anyone has attempted (or knows if it's possible) to have multiple postmasters running on separate nodes of the cluster suite. Here's the specifics: 2 node cluster, 5 postmasters on each node, 10 databases, 5 on each node. One of the advantages is that if we have a problem with a single database, we can bring that single postmaster down and not affect the balance of the databases. It appears based on our research of red hat documents that this is a feasible solution, but would love to hear from anyone who is doing something similar or knows it will not work. So we won't bleed too much.. -- Until later, Geoffrey