Question about "grant create on database" and pg_dump/pg_dumpall

From: "Murphy, Kevin" <MURPHYKE(at)email(dot)chop(dot)edu>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Question about "grant create on database" and pg_dump/pg_dumpall
Date: 2016-06-30 17:38:27
Message-ID: D39AD151.20E45%murphyke@email.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2016-06-30 19:19:09 Re: Log archiving failing. Seems to be wrong timeline
Previous Message Adrian Klaver 2016-06-30 17:21:55 Re: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)