Is it expected that "grant * on database" grants are dumped only by `pg_dumpall 
-s` and not by `pg_dump -s` or `pg_dumpall -g`?

Some people might assume that to restore a cluster it should be sufficient to 
restore pg_dumpall globals output followed by individual pg_dump output. 
Seemingly, this would not be a good assumption, unless plain `pg_dump` actually 
incorporates these grants even though `pg_dump -s` does not.  Regardless, 
something about this situation seems off to me. I'm using 9.5, BTW.

I've seen this discussed here: 
https://www.postgresql.org/message-id/E1VYMqi-0001P4-P4%40wrigleys.postgresql.org,
 but the discussion petered out prematurely.

Thanks,
Kevin

Reply via email to