Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1C7659FA618 for ; Tue, 14 Nov 2006 16:11:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03644-09 for ; Tue, 14 Nov 2006 16:11:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 08D8E9FA5C8 for ; Tue, 14 Nov 2006 16:11:54 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id kAEKBse00586; Tue, 14 Nov 2006 15:11:54 -0500 (EST) From: Bruce Momjian Message-Id: <200611142011.kAEKBse00586@momjian.us> Subject: Re: 100% failover + replication solution In-Reply-To: <82e1a9bd0610300147m7e214893ue1306f1637bb489f@mail.gmail.com> To: Moiz Kothari Date: Tue, 14 Nov 2006 15:11:54 -0500 (EST) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/145 X-Sequence-Number: 23672 I wrote this for the 8.2 documentation. Let me know if it helps or you have other suggestions: http://developer.postgresql.org/pgdocs/postgres/failover.html --------------------------------------------------------------------------- Moiz Kothari wrote: > Guys, > > I have been thinking about this and wanted to see if it can be achived. I > wanted to make a 100% failover solution for my postgres databases. The first > thing that comes to my mind is doing it using WAL logs. Am attaching the > diagram for which i will write more here. > > I was thinking if i can have Hotsync the databases using the WAL logs. If > you see the architecture, the select goes to the SLAVE nodes and the INSERTS > goes to the MASTER database, that means there should be no transactions > happening on SLAVES (pure select). not even using "plpgsql". In this > archecture i wont even mind restarting the SLAVE nodes if i need to. > > I was reading on PIT recovery on postgres, the only current problem i am > facing with that is, i need to backup the database and move the slaves and > the apply WAL logs to it. That could be huge amount of transfer and hence a > longer downtime then moving 16mb WAL log files. > > Can someone help me out here, what i want is a continuous applying of WAL > logs once i have brought the database up. I want to elimiate the backup of > master to be restored to the slaves everytime i want to apply WAL to slaves. > It would be real help if someone can tell me if it is possible to apply WAL > logs to the slaves continously as soon as they are created on MASTER. I > checked other tools available and thougth this would be best approach if it > works. > > Awaiting reply soon. > > Regards, > Moiz Kothari [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +