PostgreSQL should include DB creation as an option
pg_dump has a useful command:
-C, --create Begin the output with a command to create the database itself and reconnect to the created database. (With a script of this form, it doesn't matter which database you connect to before running the script.)
Would it be possible for backupninja to include an additional option to create the database upon restore?
#1 Updated by intrigeri about 6 years ago
- Category set to postgresql handler
- Status changed from New to Confirmed
- Priority changed from Normal to Low
Adding support to pass arbitrary additional options to
pg_dumpall (possibly needs two separate options) would be great. Patches are welcome!