From d49aeeceb190c49537e5ba90e3a38afd2d085517 Mon Sep 17 00:00:00 2001
From: Pierre-Louis GONON <pierre-louis.gonon@dalibo.com>
Date: Tue, 21 Oct 2025 13:33:20 +0200
Subject: [PATCH] docs: Migration sections and task dependencies

---
 docs/references/dump.md | 34 ++++++++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)

diff --git a/docs/references/dump.md b/docs/references/dump.md
index c141ceb11..b6792c41c 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 |
-- 
GitLab