Restoring on top of existing DB

[janhoy]

Hi, thanks for a great product.

I'm about to test and document the restore procedure for my project, since if you cannot restore, there is little value in a backup.

So in our case the typical restore would be after a data corruption, human mistake or after rolling out a bad version of our product, that mutates the DB, and the need to roll back to the previous version of our app, and also the previous version of DB from backup.

For these cases I want to restore on top of the existing DB for simplicity, then the entire restore process is only one command. So I found that I could add --clean --if-exists to POSTGRES_EXTRA_OPTS to get the DROP xxx IF EXISTS statements added in the backup file.

Have you considered adding it as a default, or at least mentioning various restore strategies in the README?