I have written a tutorial to pgpool-II using PostgreSQL 9.0's streaming replication. The tutorial is designed to use minimum resource: a Linux box. On the box, pgpool-II, pgpoolAdmin(a PHP based pgpool-II GUI admin tool) and two PostgreSQL 9.0 instances.
Though the tutorial system is surprisingly simple, you could learn:
- How pgpool-II detects PostgreSQL failure and automatically promote a standby server to primary server
- How pgpool-II re-sync the failed node by using "online recovery" capability
Photo by brisch27 Ultra fast PostgreSQL down detection If a user connects to Pgpool-II and one of PostgreSQL servers is stopped by admin, ...
Materialized views are convenient and efficient way to retrieve information from database. Unlike ordinary views, materialized views save th...
Photo by Florian Kurz What is pgbench Pgbench is a simple tool to perform performance tests on PostgreSQL. Since pgbench comes with Post...