Backup multiple schemas from the same database #103
-
|
When using the docker compose format. How do you set either multiple target schemas or all schemas from the same database to be included in the back-up? Alternatively, would it be better practice to run a container per schema, then schema back-ups would have better segregation in the relative target storage destination. Interested in people's opinion. Thank you |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
Found out the answer for myself - single container instance can target the host, simply enable split database option and each db get split out into its own compressed file from the target host. Also found that restoring from the resulting back-up file needs tweaks due to resulting fk constraints not aligning to the related tables but nothing too serious. |
Beta Was this translation helpful? Give feedback.
Found out the answer for myself - single container instance can target the host, simply enable split database option and each db get split out into its own compressed file from the target host. Also found that restoring from the resulting back-up file needs tweaks due to resulting fk constraints not aligning to the related tables but nothing too serious.