Postgres Pro
Downloads
Home   >   mailing lists

Re: Dump & restore in directory format and permissions are largely lost? - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Dump & restore in directory format and permissions are largely lost?
Date
Msg-id CAOC+FBVYfA9y=QL2rvW751t3FffryTTyCJF40-phG5wEomOc9g@mail.gmail.com
Whole thread Raw
In response to Re: Dump & restore in directory format and permissions are largely lost?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Dump & restore in directory format and permissions are largely lost?
List pgsql-admin
Tree view
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@gmail.com> wrote:
On Tue, Jun 15, 2021 at 6:55 PM Wells Oliver <wells.oliver@gmail.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.


--

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?
Next
From: Tom Lane
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?