Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 88EBE9FB1C0 for ; Mon, 30 Oct 2006 06:23:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 08426-05 for ; Mon, 30 Oct 2006 10:23:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 765029FA376 for ; Mon, 30 Oct 2006 06:23:09 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id g2so2074437nfe for ; Mon, 30 Oct 2006 02:23:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=YaVOuT7ZlzWCyQsJy8xxRf9NpNmP2XtgFj5u+prIt/2jErA/jH7Mgg17GBbcnPDhc3XUqZruc6flv5CUb9nGmbNU25XE+oalSahmIQjVYDY+CckS8ntze0WU8FHHm6ALN6l+2Cw3EymoygBv90mZ+2HlZHrLm4p8KPf1smt4iEA= Received: by 10.82.106.14 with SMTP id e14mr379996buc; Mon, 30 Oct 2006 02:23:07 -0800 (PST) Received: by 10.82.129.11 with HTTP; Mon, 30 Oct 2006 02:23:07 -0800 (PST) Message-ID: Date: Mon, 30 Oct 2006 15:23:07 +0500 From: "Shoaib Mir" To: "Ben Suffolk" Subject: Re: 100% failover + replication solution Cc: "Moiz Kothari" , pgsql-admin@postgresql.org In-Reply-To: <7CA68A94-ED1E-49C9-ACF2-2A34936333DC@vanilla.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_66943_10549922.1162203787061" References: <82e1a9bd0610300147m7e214893ue1306f1637bb489f@mail.gmail.com> <7CA68A94-ED1E-49C9-ACF2-2A34936333DC@vanilla.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/203 X-Sequence-Number: 23506 ------=_Part_66943_10549922.1162203787061 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline There is this project which actually is not released yet, but something that you want to achieve :) http://pgfoundry.org/projects/pgpitrha Regards, ------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 10/30/06, Ben Suffolk 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. > > While its not the solution you were looking at, have you seen > PGCluser :- > > http://pgcluster.projects.postgresql.org/index.html > > I have not tried it, but was looking the other week at various fail- > over type solutions and came across it. It seems to be able to do > what you want. > > Ben > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ------=_Part_66943_10549922.1162203787061 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline There is this project which actually is not released yet, but something that you want to achieve :)

http://pgfoundry.org/projects/pgpitrha

Regards,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 10/30/06, Ben Suffolk < ben@vanilla.net> 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.

While its not the solution you were looking at, have you seen
PGCluser :-

http://pgcluster.projects.postgresql.org/index.html

I have not tried it, but was looking the other week at various fail-
over type solutions and came across it. It seems to be able to do
what you want.

Ben






---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

------=_Part_66943_10549922.1162203787061--