PostgreSQL and high availability

Mikhail Kulagin

Postgres Professional

Администратор баз данных

The highly available configurations for PostgreSQL are usually mode with the help of binary replication and some third party utilities. This talk will review the existing solutions, including a simple one based on corosync/pacemaker, which is supported by Postgres Pro. A live demo will be presented.

Another hight availability approach is proposed by the multimaster Postgres Pro extension, which provides high availability without any third-party products. A live demo and description of multimaster caveats will be presented.