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

I create a database in the first cluster and a table in that database.

I grant explicit permissions on that table to "user1" and "public".

I take a backup using pg_dump -Fc, and then restore on the second cluster (where "user1" does not exist).

The restore process says it ignored the error for the missing user, but the restored table now has no perms at all. Not even for user public.

Examining pg_restore sql output shows two separate grant commands, however the problem persists even if I pipe pg_restore output into psql. Very strange.

When a role does not exist on the restore cluster, I would like pg_restore to restore all valid permissions and simply omit those permissions from the missing role. Currently, no permissions are restored.

Source cluster version 9.6.9 (don't think this is the issue)

Destination cluster version 10.4

Thank you.