CNPG

Meetup 2025-12-cloudnativepg

Create a backuped Postgres cluster

k apply -f postgres.yaml

Create some datas

CREATE TABLE test_restauration (
    id SERIAL PRIMARY KEY,
    nom VARCHAR(100) NOT NULL,
    date_creation TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    description TEXT
);

INSERT INTO test_restauration (nom, description)
VALUES ('Test de restauration', 'Cette ligne a été ajoutée avant la restauration du cluster.');

SELECT * FROM test_restauration;

Start a manual backup

k cnpg backup chatbot

Promote another primary node

k cnpg promote chatbot chatbot-3

Delete the cluster

k delete -f postgres.yaml

Restore the cluster

k apply -f postgres-recovery.yaml