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 3971B528A8 for ; Sat, 25 Jun 2005 03:51:24 -0300 (ADT) 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 39902-06 for ; Sat, 25 Jun 2005 06:51:14 +0000 (GMT) Received: from web8607.mail.in.yahoo.com (web8607.mail.in.yahoo.com [202.43.219.82]) by svr1.postgresql.org (Postfix) with SMTP id 6A1055288D for ; Sat, 25 Jun 2005 03:51:12 -0300 (ADT) Received: (qmail 65078 invoked by uid 60001); 25 Jun 2005 06:51:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=NdDy36Qp6K3mE42gCRXfyqYk7eA0MlUVGF2hcci64z6ALDCmx6qMlyqv/rPvv5DTADLLRNnsT1uNWslfgDQCFY18C4ZJWYHsabVi4eDryjlhoGZw/gF8lPVAsf7lzF56TvMBhulqiUvKdBHVDApBC+1CWA5BkWkb7n6Qyv4qQI0= ; Message-ID: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com> Received: from [61.11.18.83] by web8607.mail.in.yahoo.com via HTTP; Sat, 25 Jun 2005 07:51:06 BST Date: Sat, 25 Jun 2005 07:51:06 +0100 (BST) From: hellz waren Subject: real time replication of pgsql database To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.776 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, RCVD_IN_NJABL_PROXY X-Spam-Level: ** X-Archive-Number: 200506/209 X-Sequence-Number: 17964 hi, we are designing a heavy duty database in pgsql that expects to grow at an average of 100 MB spread over tables of 250 tables. We require always on database (24 X 7) database. And if one fails, the other one needs to start up. Could you someone tell me if there's any open source project that enables real time replication of data back up. I can use heartbeat, mon etc then to awake the other server if the main server is down. Thanks, Hrishikesh __________________________________________________________ How much free photo storage do you get? Store your friends 'n family snaps for FREE with Yahoo! Photos http://in.photos.yahoo.com