diff --git a/docs/references/dump.md b/docs/references/dump.md index c141ceb11a81f48432f50f87985ad01b23833764..b6792c41c57d6b5cad4ceb3caf27cbaed86fdb8e 100644 --- a/docs/references/dump.md +++ b/docs/references/dump.md @@ -73,3 +73,37 @@ Chunk size varies seconding source DBMS, see table below. | longblob | 128kB | PostgreSQL Migrator inlines long columns for tables with average row size below 64KiB. + + +## Section + +The dump process is divided into three sections. + +Each task can depend on an entire section, or on one or more other tasks. + + +### `pre-data` + +| Task | Dependencies | +|---|---| +| CREATE ROLE | | +| CREATE SCHEMA | | +| CREATE TABLE | CREATE SCHEMA | +| CREATE SEQUENCES | CREATE SCHEMA | + + +### `data` + +| Task | Dependencies | +|---|---| +| COPY TABLE | CREATE TABLE | +| RESTART SEQUENCES | all CREATE SEQUENCES | +| RESTART IDENTITIES | all CREATE TABLE containing identity column | + + +### `post-data` + +| Task | Dependencies | +|---|---| +| CREATE INDEX | CREATE TABLE / COPY TABLE | +| ALTER DEFAULT | pre-data section |