Received: from svr1.fondos.net ([216.247.232.112]) by hub.org (8.10.1/8.11.0) with SMTP id e9GIGCW28802 for ; Mon, 16 Oct 2000 14:16:12 -0400 (EDT) (envelope-from oserra@fondos.net) Received: (qmail 1313 invoked by alias); 16 Oct 2000 18:20:21 -0000 Received: from unknown (HELO Oscar) (212.80.170.130) by 216.247.232.112 with SMTP; 16 Oct 2000 18:20:21 -0000 From: "Oscar Serrano" To: "Postgres interfaces" Subject: 2 computers 1hd 2 postgres daemons. Is it possible? Date: Mon, 16 Oct 2000 20:15:57 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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) In-Reply-To: <39E650A2.A4A68476@selectacast.net> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal X-Archive-Number: 200010/125 X-Sequence-Number: 1482 Hi men :-) Just one question for those of you who have spent many time with postgres. I want to create a load balancing and High Availability system with two servers. This two server have a common hard disk: A RAID 5 server connected to them by the LAN. I have a hardware machine (WSD+ from RADWARE) that manages the load balancing. I want to have, two servers, and two postgres installations, one in each server, but with a common PGDATA directory in the RAID. So, if one of the servers crashes, people can still get the information from the other server. Esentially, what I want is, two postgres (one in each machine) with a shared PGDATA directory, and that both postgres can access and do Inserts in the tables, and when one postgres does an insert, the second sees what the first has inserted. Thanks.