[GENERAL] Question about "grant create on database" and pg_dump/pg_dumpall

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

Re: [GENERAL] pg_dump permssion denied problem

On 5/1/15, 11:10 AM, "Murphy, Kevin" mailto:murph...@email.chop.edu>> wrote: Here's a variation on the theme of http://postgresql.nabble.com/Issue-dumping-schema-using-readonly-user-td5837749.html In a 9.3.4 database I don't own, I am able to create schemas, so I do, an

[GENERAL] pg_dump permssion denied problem

Here's a variation on the theme of http://postgresql.nabble.com/Issue-dumping-schema-using-readonly-user-td5837749.html In a 9.3.4 database I don't own, I am able to create schemas, so I do, and I create various tables within a schema. However, I am unable to use pg_dump (9.3.6) to dump the st