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.
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.
regards, tom lane