pg_dump: skip pg_init_privs entries for non-existent roles

Title

CI (CFBot)

Needs rebase! Needs rebase since 4 days. Failing since 1 week.
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 (6 days ago)

Latest email

2026-07-02 21:09:54 (6 days ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Ready for Committer

Target version

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-02 21:09:54 by Laurenz Albe <laur at aon.at>
Latest attachment (performance_tests.txt) at 2026-06-24 12:19:47 from Hüseyin Demir <huseyin.d3r at gmail.com>
    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-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