Re: BUG #14788: `pg_restore -c` won't restore schema access privileges.

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> fujimoto(at)ceptord(dot)net writes:
> > [ dump to archive, then pg_restore with -c option ]
>
> > Now all the access privileges on the public schema are gone:
>
> I can confirm this is broken in HEAD: "pg_dump -c test >test.out"
> produces a script including "GRANT ALL ON SCHEMA public TO PUBLIC",
> but "pg_dump -Fc test >test.dump; pg_restore -c test.dump" produces
> a script lacking that.

Ugh.

> Stephen attempted to fix this in 330b84d8c, but the fix was evidently done
> incorrectly. There should never be any difference between the results of
> these two procedures. I've not studied 330b84d8c, but my strong suspicion
> is that the logic was added to the wrong place in pg_dump.

I'm afraid it's not quite that simple, unfortunately.

I'll see what I can do though. I'm really curious how this was working
previously..

Thanks!

Stephen