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) Needs rebase! Needs rebase since 3 days. Failing since 3 days.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Bugfix
Created 2026-06-19 06:30:03
Last modified 2026-07-02 21:10:41 (3 weeks ago)
Latest email 2026-07-26 17:25:14 (3 days ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Ready for Committer
Target version 19
Authors Hüseyin Demir (demir)
Reviewers Laurenz Albe (laurenz), 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-07-26 17:25:14 by Rui Zhao <zhaorui126 at gmail.com>
Latest 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>
    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-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