Re: BUG #14009: pg_restore not restoring privilegs when one login/group role is missing - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14009: pg_restore not restoring privilegs when one login/group role is missing
Date
Msg-id 20365.1457555577@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14009: pg_restore not restoring privilegs when one login/group role is missing  (alexander@spiteri.org)
Responses Re: BUG #14009: pg_restore not restoring privilegs when one login/group role is missing
List pgsql-bugs
alexander@spiteri.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14010: Multi-valued Index-only scans do not properly handle nulls in search
Next
From: Glen Takahashi
Date:
Subject: Re: BUG #14010: Multi-valued Index-only scans do not properly handle nulls in search