Example Deployment of PostgreSQL HA with Pgpool-II
 |
Using content from this example is acceptable, but does not preclude the need for validating its function on your specific deployment. Strong and thorough testing and validation of your HA implementation is required.
|
The following example will implement the PostgreSQL HA architecture illustrated in the following diagram.
• Data replication managed through PostgreSQL synchronized streaming replication.
• Client requests are routed through Pgpool-II.
This example contains the following sections:
1. Pre-installation requirements
2. Install PostgreSQL
3. Set up the database for ThingWorx
4. Configure database for streaming replication as node0
5. Configure database for streaming replication as node1
6. Configure database for streaming replication as node2
7. Verify streaming replication to all nodes
8. Install and configure Pgpool
9. Configure Watchdog service for Pgpool-II master and standby nodes
10. Failover Scenarios