Re: Schema dump/restore not restoring grants on the schema

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Mike Roest <mike(dot)roest(at)replicon(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Schema dump/restore not restoring grants on the schema
Date: 2019-10-01 18:12:21
Message-ID: a9002b99-6267-056d-2db1-4ab5f832de10@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/1/19 8:49 AM, Mike Roest wrote:
> Thanks for the reply Tom,
>    We're going to look at removing the filtering on the pg_restore
> which I think should allow us to move forward since we have the pg_dump
> already filtered.

It will. If you want to verify do:

pg_restore -f testschema.txt test.backup

That will give you a plain text version of the restore.

>
> --Mike
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Horsnell 2019-10-01 19:25:37 Re: Behaviour adding a column with and without a default (prior to PG11)
Previous Message Adrian Klaver 2019-10-01 18:08:11 Re: Schema dump/restore not restoring grants on the schema