Schema dump/restore not restoring grants on the schema

2019-10-01 Thread Mike Roest
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

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

2019-10-01 Thread Mike Roest
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

pg_visible_in_snapshot clarification

2023-08-28 Thread Mike Roest
Hey There, I'm looking for some clarification around pg_visible_in_snapshot function. As it seems to not be working the way I would expect or the way the documentation is setup. I've attempted this on pg13 and pg15 and am getting the same behaviour. 3 connections via psql 2 to the primary and