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)
-
What is row pattern recognition feature? Row pattern recognition (RPR) is a feature defined in the SQL standard. It allows to search for a s...
-
There are several timeout parameters in Pgpool-II. In this blog I will explain those parameters used for connection management. Below is...
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