In Postgresql, after pg_dump the access privileges on the database itself are not restored
Why are the access privileges on the database itself not restored?


It's a bug, or a design oversight. Though the responder to that report doesn't think so.

pg_dumpall --globals-only doesn't dump rights on the database. Neither does pg_dump as part of the database dump.

So grants on databases only get included in a full pg_dumpall.

I'll make some noise about it by poking this thread.