---
title: "Discussion on \"Zero-Downtime Postgres Migrations: The Expand-and-Contract Playbook\" | Hashnode"
description: "Discussion on \"Zero-Downtime Postgres Migrations: The Expand-and-Contract Playbook\". How to change Postgres schemas on a live app without locking tables or breaking deploys, using expand-and-contract, lock timeouts & batched backfills."
url: "https://hashnode.com/posts/zero-downtime-postgres-migrations/6ad04f438af58f94d08aef36"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Zero-Downtime Postgres Migrations: The Expand-and-Contract Playbook](https://bytebridgetalentllc.hashnode.dev/zero-downtime-postgres-migrations?utm_source=hashnode&utm_medium=feed)

How to change Postgres schemas on a live app without locking tables or breaking deploys, using expand-and-contract, lock timeouts & batched backfills.

Oct 15 · 6 min read · bytebridgetalentllc.hashnode.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#databases](https://hashnode.com/tag/databases)
-   [#devops](https://hashnode.com/tag/devops)
-   [#backend](https://hashnode.com/tag/backend)
-   [#migrations](https://hashnode.com/tag/migrations)

## Written by

[ByteBridge Talent LLC team](https://hashnode.com/@bytebridgetalentllc)

@bytebridgetalentllc

  
[View profile](https://hashnode.com/@bytebridgetalentllc)

Practical notes on CI/CD, cloud and platform engineering from ByteBridge Talent LLC, an E-Verify enrolled tech staffing firm in Grand Island

Practical notes on CI/CD, cloud and platform engineering from ByteBridge Talent LLC, an E-Verify enrolled tech staffing firm in Grand Island, Nebraska.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.