Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Dump & restore in directory format and permissions are largely lost?
Date
Msg-id CAKFQuwYHezea03kxRTcHg3Jo8+c-xQo8TXdDipHj6woaKacGCw@mail.gmail.com
Whole thread Raw
In response to Dump & restore in directory format and permissions are largely lost?  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Dump & restore in directory format and permissions are largely lost?
List pgsql-admin
Tree view
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: Wells Oliver
Date:
Subject: Dump & restore in directory format and permissions are largely lost?
Next
From: Wells Oliver
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?