Re: Dump & restore in directory format and permissions are largely lost?

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tue, Jun 15, 2021 at 6:55 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
> 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(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>