pg_dance

A fun project to make PostgreSQL people dancing. Especially during conferences. ;)

Requirements

Kubernetes Environment

Run Kubernetes cluster in your own laptop with kind.

Install kind by following the official documentation: https://kind.sigs.k8s.io/docs/user/quick-start/

kubectl

Control Kubernetes resources with its own client.

Install it from the official documentation: https://kubernetes.io/docs/tasks/tools/#kubectl

CloudNativePG

Run PostgreSQL in Kubernetes with CNPh.

Install the latest version from its official documentation: https://cloudnative-pg.io/docs/devel/installation_upgrade#directly-using-the-operator-manifest

Kubectl Plugin for CloudNativePG

Manage your CNPG cluster with the CNPG plugin.

Install it from its official documentation: https://cloudnative-pg.io/docs/devel/kubectl-plugin/#install

Quick Start

Create a kind cluster

kind create cluster -n pg_dance

Deploy the CNPG operator

Once the kind cluster is ready:

kubectl apply --server-side -f \
  https://raw.githubusercontent.com/cloudnative-pg/cloudnative-pg/release-1.28/releases/cnpg-1.28.0.yaml

Wait for the Operator to be ready

kubectl rollout status deployment \
  -n cnpg-system cnpg-controller-manager

Deploy the CNPG Clsuter for pg_dance

kubectl apply -f pg_dance.yaml

Wait until the cluster is up and running

kubectl wait --for=condition=Ready --timeout=600s cluster/pg-dance

Initialize the database

bash init.sh

Exec pg_dance

bash pg_dance.sh