Re: BUG #14009: pg_restore not restoring privilegs when one login/group role is missing

Please find a test case attached. I tried to put as much detail as i could.

Regards,
Alexander Spiteri

On 9 March 2016 at 21:32, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> alexander(at)spiteri(dot)org writes:
> > I have just installed a new instance of postgres 9.5.1 and have an issue
> > with restoring the database, specifically privilges of the login/group
> > roles.
>
> > In the past I was working with postgres 8.4 and when I took a backup from
> > the live server to the testing server pg_restore would grant all
> privilages
> > to login/group roles which existed on the testing server and give an
> error
> > for those that do not exist.
>
> > On the new 9.5.1 server when I try to restore a database, if one
> login/group
> > role does not exist pg_restore gives an error about it and then does not
> > grant any rights to all the other login/group roles that do exist. No
> errors
> > / notices are issued about the grants that are not applied.
>
> That's fairly hard to believe. Can you provide a self-contained test
> case?
>
> regards, tom lane
>