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
Please enjoy!
Subscribe to:
Post Comments (Atom)
Dynamic spare process management in Pgpool-II
Pre-fork architecture in Pgpool-II Pgpool-II uses fixed number of pre-forked child process which is responsible for accepting and handling e...
-
There are several timeout parameters in Pgpool-II. In this blog I will explain those parameters used for connection management. Below is... -
Recently I got questions on pgpool-II's health check parameters. In this article I will try to explain them. "Health check" ...
Tutorial page not opening, can you post instructions somwhere else?
ReplyDeleteHi. At least with pgdg rpms you CAN have multiple instances, just ln -s /etc/init.d/postgresql-9.1 /etc/init.d/postgresql2-9.1 and then create /etc/sysconfig/postgresql2-9.1 with port configurations.
ReplyDeleteWell done! Pleasant post! This truly helps me to discover the solutions for my inquiry. Trusting, that you will keep posting articles having heaps of valuable data. You're the best!
ReplyDeleteData Science course in rajaji nagar
Data Science with Python course in chenni
Data Science course in electronic city
Data Science course in USA
Data science course in pune | Data Science Training institute in Pune