search

postgrespro / pg_probackup

Backup and recovery manager for PostgreSQL
https://postgrespro.github.io/pg_probackup/
Other
703 stars 86 forks source link

Single database backup #595

Closed MiyamuraMiyako closed 1 year ago

MiyamuraMiyako commented 1 year ago

It seems pg_probackup backup operation is all databases scope. Is there a way to backup or restore a single database without affecting other databases and without downtime?

Burus commented 1 year ago

The main root cause is PostgreSQL cluster architecture with numerous databases in one instance.

No it's dangerous and we cant do backup for single DB right now.

You can try to use our partial restore features with flags "resrtore --db-exclude" (https://postgrespro.ru/docs/postgrespro/15/app-pgprobackup?lang=en) from full backup or make another architecture for your backend with different databases in each PostgreSQL.