PG Backup and Restore

[deepakduggirala]

Improve Postgres Restore Efficiency

Current State:
The current backup script generates a file containing individual INSERT statements for data restoration. While this approach ensures data consistency, it can lead to inefficient and time-consuming restoration processes, especially for large databases.

Proposed Improvement:
To enhance the restore efficiency for Postgres databases, we should explore alternative methods for generating backup files or improving the restore process.

Scenarios

• different scenarios, when to backup schema + data / only data, how it interacts with prisma migrate?
• reset db and add data on a blank instance?
• restore to previous schema and data after a change that has gone bad
• scheduled backups, if db is gone, how to restore it again?