Database Administration & Monitoring Vertically scale your PostgreSQL infrastructure with pgpool – 3 – Adding another standby 28.03.2017 by Daniel Westermann In the first and second post in this series we did the basic pgpool setup including the watchdog configuration and then did a simple setup for automatically failover from a PostgreSQL master instance in case it(…)
Database Administration & Monitoring Vertically scale your PostgreSQL infrastructure with pgpool – 2 – Automatic failover and reconfiguration 24.03.2017 by Daniel Westermann In the first post of this little series we did the basic setup of pgpool and configured the watchdog. So, as of now, pgpool uses a VIP which is active on one of the(…)
Database Administration & Monitoring Vertically scale your PostgreSQL infrastructure with pgpool – 1 – Basic setup and watchdog configuration 16.03.2017 by Daniel Westermann I have written some posts on how you can make your PostgreSQL deployment high available by using PostgreSQL's streaming replication feature in the past ( 1, 2 ). The main issue you'll have to(…)