how does a backup cause write contention? are you backing up to the same disk? a... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

aeyes on May 19, 2023 | parent | context | favorite | on: Migrating from Supabase

how does a backup cause write contention? are you backing up to the same disk?

also why are backups using pg_dump? that’s not a backup.

nfm on May 19, 2023 | [–]

https://www.postgresql.org/docs/current/app-pgdump.html

> pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently.

paulryanrogers on May 20, 2023 | [–]

Possibly MVCC keeping a snapshot so the whole dump is consistent.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact