[Pgpool-general] Database redundancy recommended approach

[Daniel.Crespo at l-3com.com]

>From your point of view, what is the recommended approach to have the
following scenario working without human intervention?

 

*         2 DB Servers (DB0 and DB1)

*         1 pgpool instance (in a thrid server)

*         Streaming replication from DB0 (master) to DB1 (slave)

*         If DB0 fails, DB1 must become primary.

*         As soon as DB0 is ready again, make it slave of DB1.

*         With DB1 as primary, if it fails, DB0 must become primary
(again).

*         And so on.

 

Thanks,

-Daniel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101020/a17f81d4/attachment.html>