| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | alexander(at)spiteri(dot)org |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14009: pg_restore not restoring privilegs when one login/group role is missing |
| Date: | 2016-03-09 20:32:57 |
| Message-ID: | 20365.1457555577@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Breen Hagan | 2016-03-09 22:44:18 | Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled |
| Previous Message | Tom Lane | 2016-03-09 19:58:13 | Re: BUG #14010: Multi-valued Index-only scans do not properly handle nulls in search |