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.b
On 10/1/19 7:53 AM, Tom Lane wrote:
Mike Roest writes:
Just trying to find out if something is intended behaviour. When doing a
schema filtered pg_dump the created dump file includes the grants on that
specific schema (in our case a grant usage to a unprivleged user) but doing
a pg_restore
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.
--Mike
Mike Roest writes:
>Just trying to find out if something is intended behaviour. When doing a
> schema filtered pg_dump the created dump file includes the grants on that
> specific schema (in our case a grant usage to a unprivleged user) but doing
> a pg_restore with a -n does not restore that
Hi There,
Just trying to find out if something is intended behaviour. When doing a
schema filtered pg_dump the created dump file includes the grants on that
specific schema (in our case a grant usage to a unprivleged user) but doing
a pg_restore with a -n does not restore that grant however
ind
