> 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 :-
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