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

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Date: 2016-07-11 22:48:08
Message-ID: 5e6af34f945e4ddab2caf2a26fa57137@EX13D03UWC002.ant.amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Attachment Content-Type Size
restore_invalid_setconfig.patch application/octet-stream 10.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-07-11 22:49:06 Re: BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail
Previous Message bossartn 2016-07-11 22:36:41 BUG #14242: Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail