PostegresSQL HA

Authored jointly with Scott Mead, Sr. Architect OpenSCG and Architect of PostgresHA.

PostgresHA is Highly Available (HA) PostgreSQL.

 

PostgresHA Architecture

 

 

More in http://www.openscg.com/2013/04/postgresql-clustering/

BUT, Denis Lussier, C-Founder – CTO of EnterpriseDB says…

In general, we do NOT recommend running PostgresHA running synchronus replication. We recommend running PostgreSQL streaming repliction in Asynch mode. Monitoring and alerting must be configured if the slave node falls behind a certain tolerance of keeping up with the master.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.