Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail

Nathan Bossart <bossartn@amazon.com>

From: "Bossart, Nathan" <bossartn@amazon.com>

To: "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>

Date: 2016-07-11T22:48:08Z

Lists: pgsql-bugs

Attachments

restore_invalid_setconfig.patch (application/octet-stream) patch

A simple fix for this issue would be to temporarily create the role just for the ALTER ROLE SET command generated by pg_dumpall.  I've attached a patch that does this.
 
Nathan

Commits

Fix some inappropriately-disallowed uses of ALTER ROLE/DATABASE SET.
- c7f0275fbd4f 11.12 landed
- c39aa1e878cb 13.3 landed
- a7fcb62852dc 12.7 landed
- 69d5ca484b69 14.0 landed
- 46b6635b7742 10.17 landed
- 041f4efd25e2 9.6.22 landed