>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

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to