Jun 12

4 min read

Live Postgres database clone without downtime

TL;DR: How to create a clone of a running Postgres database using LVM2 Snapshot capability

Perfect Postgres database clones!

Motivation

There is a lot of literature about how to create backups for Postgres databases.

Most of them use the pg_start_backup and LVM2 Snapshot capabilities to create backups and PITR recoveries.

--

More from JM Robles

Beyond-Full-stack developer #go #python #kubernetes #terraform #devops

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Raphael De Lio

How a Brazilian young man became a software developer using broken smartphones

Stanley Lee

Understanding form_for and form_tags

Michael Smith

🕹️It’s time to play and DUNK IT!

Eric Kleppen

in

Level Up Coding

How to Create Powerful Web Apps and Dashboards using Dash 2.0

JM Robles

API Spec: where should it be?

zeg solutions

What is the difference between BCP and DRP? Business continuity plan and recovery from the accident

Value Finance

VFT LIQUIDITY POOL MINING NOW LIVE

Priyam Chauhan

Ansible: 30 Most Important Modules for DevOps Professional — Part 1

About Help Terms Privacy

Get the Medium app

JM Robles

JM Robles

Beyond-Full-stack developer #go #python #kubernetes #terraform #devops

More from Medium

Jonas Neumann

in

NEW IT Engineering

Developer Tools — AWS vs GCP part 6

DataStax

in

Building the Open Data Stack

Create Cassandra Apps on AWS in Minutes, Not Weeks

Yusuf Tayman

Serverless Interactive Slack Bot: Part One

serverless-slack-bot

ukyen

in

Towards Dev

Deploy a Webhook Endpoint Built with FastAPI to API Gateway and Cloud Run

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Knowable