Re: 100% failover + replication solution

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(at)vanilla(dot)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
>