Re: Schema dump/restore not restoring grants on the schema - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Schema dump/restore not restoring grants on the schema
Date
Msg-id a9002b99-6267-056d-2db1-4ab5f832de10@aklaver.com
Whole thread Raw
In response to Re: Schema dump/restore not restoring grants on the schema  (Mike Roest <mike.roest@replicon.com>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Schema dump/restore not restoring grants on the schema
Next
From: Joe Horsnell
Date:
Subject: Re: Behaviour adding a column with and without a default (prior toPG11)