Schedule - PGConf.DE 2023
PG HA – Cluster your application in 40 minutes
Room: Room 1
PostgreSQL has been one of the most popular open source databases for several years now and thus plays an important role for more and more applications. A side effect of open source databases has been that they are ‘simply installed’ in many situations. Similar to MySQL, this often happens, for example, when setting up online shops, CMS systems or a domain of one’s own. It is not uncommon for this database to grow historically and thus become critical to the company. So what happens if such a database suddenly becomes unavailable? PostgreSQL provides several solutions for this problem, which we will outline in this lecture. I would like to describe a classic web application setup and show you how to add some high availability to the application by setting up a high available PostgreSQL cluster together with the lightway connection pooler PgBouncer. An to make clear that it’s not so complex as you may think, I will do this live within 40 minutes.