Deploying PostgreSQL on Kubernetes

by Jimmy Angelakos

At: FOSDEM 2019

A look at some of the ways available to deploy Postgres in a Kubernetes cloud environment, either in small scale using simple configurations, or in larger scale using tools such as Helm charts and the Crunchy PostgreSQL Operator. A short introduction to Kubernetes will be given to explain the concepts involved, followed by examples from each deployment method and observations on the key differences. A look at some of the ways available to deploy Postgres in a Kubernetes cloud environment, either in small scale using simple configurations, or in larger scale using tools such as Helm charts and the Crunchy PostgreSQL Operator. A short introduction to Kubernetes will be given to explain the concepts involved, followed by examples from each deployment method and observations on the key differences.

Room: UA2.220 (Guillissen)
Scheduled start: 2019-02-03 13:00:00+01

[kojak]

Great lecture. No typical nerdy shenanigans, just the juice

[SosetaFurioasaJr]

1. Get a PostgreSQL / PostGis container image
2. Create a ConfigMap (which is like a fake volume that you can mount onto the pods and it only contains configuration)
3. Create a PersistentVolume and a PersistentVolumeClaim for the database that will use these resources.
4. Create a Deployment that describes how you use the container image and the volume.
5. Create a Service (of type NodePort) to expose the above.
6. Connect to your database via exposed port or kubectl to port forward and connect on localhost.