Yes. The target and source servers have the same users and roles, which is why their permissions being absent from the same objects on the target where they exist in the source is very confusing to me.
I also do a pg_restore -l -Fd on the dump file, and I don't see any GRANT or REVOKE statements: should I expect that?
On Tue, Jun 15, 2021 at 5:58 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Tue, Jun 15, 2021 at 6:55 PM Wells Oliver <wells.oliver@xxxxxxxxx> wrote:Am I missing something obvious here?You specified a host in the restore command - since pg_dump doesn't dump global objects like roles are you sure the restore cluster has the necessary roles present?David J.
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
