Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore: All GRANTs on table fail when any one role is missing - Mailing list pgsql-bugs

From Haribabu Kommi
Subject Re: pg_restore: All GRANTs on table fail when any one role is missing
Date
Msg-id CAJrrPGcaF4uDdf_14FkUYGqcseU-5EyRXRLvsNWx3Yp9bvK=dQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore: All GRANTs on table fail when any one role is missing  (Moshe Jacobson <moshe@neadwerx.com>)
Responses Re: pg_restore: All GRANTs on table fail when any one role is missing
List pgsql-bugs
Tree view
On Tue, Jul 24, 2018 at 5:14 AM Moshe Jacobson <moshe@neadwerx.com> wrote:
On Tue, Jul 17, 2018 at 12:02 PM Moshe Jacobson <moshe@neadwerx.com> wrote:
Here is a reproduction of the problem exclusively on 10.4. 

Can anyone validate this bug?

I am not able to reproduce the issue.

>REVOKE
>ERROR:  role "user1" does not exist
>Time: 0.134 ms

The process of grant doesn't execute, because of this reason, there are no permissions
on that table. In my test, after failure of user1, the next grant is successful. 

Try generating the sql file with pg_restore output and pass it to psql and check.

Regards,
Haribabu Kommi
Fujitsu Australia

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15303: Postgres fail to start if pg_wal is symlink,and works when it's a junction point
Next
From: Amit Langote
Date:
Subject: Re: Scanning all partition when more than 100 items in "where id in()" clause