How to test PostgreSQL 16 beta in your Kubernetes cluster

Gabriele Bartolini
June 7, 2023 • 2 minutes
blog image

PostgreSQL 16 Beta 1 was recently released by the PostgreSQL Global Development Group, containing previews of all features that will be available when PostgreSQL 16 is made generally available.

The CloudNativePG community has made available the operand container images for PostgreSQL 16 beta 1 in our postgres-container image registry to be used with the CloudNativePG operator. The images are tagged with the ‘16beta1’ or ‘16’ label, and are not intended for production.

Please join us in testing the new features of PostgreSQL 16 with CloudNativePG, and help us diagnose and fix bugs in Postgres before the final launch.

Here follows a quick example of a 3 instance Postgres 16 ‘Cluster’ manifest to be deployed in your Kubernetes cluster.

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
 name: pg16

spec:
 imageName: ghcr.io/cloudnative-pg/postgresql:16beta1
 instances: 3
 storage:
  size: 1Gi

Once deployed, you can easily verify the version with:

kubectl exec -ti pg16-1 -c postgres -- psql -qAt -c 'SELECT version()'

Returning:

PostgreSQL 16beta1 (Debian 16~beta1-2.pgdg110+1) on x86_64-pc-linux-gnu,
  compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

If you are interested in trying CloudNativePG on your laptop with ‘kind’ (Kubernetes in Docker), follow the instructions you find in the Quickstart.

One last note: at the moment, PGAudit is not compatible with PostgreSQL 16 and cannot be used with the operator. There’s a pull request for PostgreSQL 16 support.

Categories in this blog post