PgBouncer K8s tutorial

The PgBouncer K8s Operator delivers automated operations management from day 0 to day 2 on the PgBouncer - the lightweight connection pooler for PostgreSQL. It is an open source, end-to-end, production-ready data platform on top of Juju.

As a first step, this tutorial will show you how to get PgBouncer K8s up and running. Then, you will learn a variety of operations such as adding replicas and enabling Transport Layer Security (TLS).

In this tutorial, we will walk through how to:

• Set up an environment using Multipass with MicroK8s and Juju.
• Deploy PgBouncer K8s using a single command.
• Configure TLS certificate in one command.

Requirements

While this tutorial intends to guide and teach you as you deploy PgBouncer K8s, it will be most beneficial if:

• You are familiar with basic terminal commands.
• You are familiar with basic PostgreSQL and PgBouncer concepts.
• You are familiar with Charmed PostgreSQL K8s
• Your machine fulfils the minimum requirements.

Step-by-step guide

Here’s an overview of the steps you will take in this tutorial:

• Set up the environment
• Deploy PgBouncer
• Managing your units
• Enable security
• Clean up your environment