pg_dump: skip pg_init_privs entries for non-existent roles

Edit
ID 6915
Title pg_dump: skip pg_init_privs entries for non-existent roles
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 1, First patch: +269−3, All patches: +269−3
Tags Bugfix
Created 2026-06-19 06:30:03
Last modified 2026-09-04 16:14:51 (5 days ago)
Latest email 2026-09-09 16:29:00 (7 hours ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version 19
Authors Hüseyin Demir (demir)
Reviewers Laurenz Albe (laurenz), solai v (solaiv), Rui Zhao (zhaorui) Become reviewer
Committer
Links
Emails
BUG #19483: pg_upgrade fails with orphan records in pg_init_priv catalog table
First at 2026-05-18 05:06:24 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-09-09 16:29:00 by Rui Zhao <zhaorui126 at gmail.com>
Latest attachment (v9-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-09-04 07:00:47 from Hüseyin Demir <huseyin.d3r at gmail.com>
    Attachment (v9-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-09-04 07:00:47 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: No)
    Attachment (0001-pg_dump-register-the-dangling-initprivs-test-and-let.patch) at 2026-08-10 16:48:19 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (v8-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-08-02 09:41:40 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: No)
    Attachment (0001-pg_dump-make-dangling-initprivs-test-exercise-the-fix.patch) at 2026-07-26 17:25:14 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (v7-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-07-10 17:37:26 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: Yes)
    Attachment (performance_tests.txt) at 2026-06-24 12:19:47 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: No)
    Attachment (v5-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-06-24 06:14:53 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: Yes)
    Attachment (quote-all-digit-role-names-in-aclitemout.patch) at 2026-06-22 18:30:54 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v4-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-06-22 05:44:45 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: Yes)
    Attachment (ext.tgz) at 2026-06-20 21:53:01 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: No)
    Attachment (v3-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-06-19 07:40:47 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: Yes)
    Attachment (v2-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-06-19 06:25:47 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pg_dump-skip-dangling-initprivs.patch) at 2026-06-12 16:22:03 from Hüseyin Demir <huseyin.d3r at gmail.com> (Patch: Yes)
History
When Who What
2026-09-04 16:14:51 Hüseyin Demir (demir) New status: Needs review
2026-09-04 07:32:37 CFbot Patch does not need rebase anymore
2026-08-30 16:31:36 Andrey Borodin (x4m) New status: Waiting on Author
2026-08-10 17:19:27 CFbot Patch needs rebase
2026-08-10 11:42:10 solai v (solaiv) Added solaiv as reviewer
2026-08-02 10:16:36 CFbot Patch does not need rebase anymore
2026-08-01 00:00:10 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-26 17:36:29 CFbot Patch needs rebase
2026-07-10 17:52:32 CFbot Patch does not need rebase anymore
2026-07-08 09:16:05 Rui Zhao (zhaorui) Added zhaorui as reviewer
2026-07-05 03:11:27 CFbot Patch needs rebase
2026-07-02 21:10:41 Laurenz Albe (laurenz) New status: Ready for Committer
2026-06-25 12:12:13 Hüseyin Demir (demir) New status: Needs review
2026-06-24 06:39:31 CFbot Patch does not need rebase anymore
2026-06-23 08:41:06 Laurenz Albe (laurenz) New status: Waiting on Author
2026-06-22 18:32:28 CFbot Patch needs rebase
2026-06-22 17:33:41 Laurenz Albe (laurenz) New status: Ready for Committer
2026-06-20 22:06:25 Laurenz Albe (laurenz) Added laurenz as reviewer
2026-06-20 22:06:22 Laurenz Albe (laurenz) New status: Waiting on Author
2026-06-19 07:51:46 Hüseyin Demir (demir) Attached mail thread 19483-80de42dc4e62cfd6@postgresql.org
2026-06-19 07:51:40 Hüseyin Demir (demir) Detached mail thread 19483-80de42dc4e62cfd6@postgresql.org
2026-06-19 06:30:03 Hüseyin Demir (demir) Attached mail thread 19483-80de42dc4e62cfd6@postgresql.org
2026-06-19 06:30:03 Hüseyin Demir (demir) Created patch record
Edit