<div dir="ltr"><span style="font-size:12.8px">On Tue, Jul 5, 2016 at 06:39 AM, Haribabu Kommi</span><br
style="font-size:12.8px"/><span style="font-size:12.8px">kommi(dot)haribabu(at)gmail(</span><span
style="font-size:12.8px">do<wbr/>t)com wrote:</span><br style="font-size:12.8px" /><br style="font-size:12.8px"
/><blockquotestyle="font-size:12.8px;margin:0px 0px 0px 40px;border:none;padding:0px">Still i feel the GRANT statements
shouldbe present, as the create<br />database statement<br />is generated only with -C option. So attached patch
producesthe GRANT<br />statements based<br />on the -x option.</blockquote><br style="font-size:12.8px" /><span
style="font-size:12.8px">Theattached patch does the job fine. However, I am a little skeptical about this addition,
since,it is clearly mentioned in the documentation of pg_dump that it would not restore global objects, then why
expectingthis. This addditon makes pg_dump -C somewhat special as now it is restoring these grant statements. Only if
weconsider the popular method of dump-restore mentioned in the thread (</span><a
href="https://www.postgresql.org/message-id/E1VYMqi-0001P4-P4%40wrigleys.postgresql.org"style="font-size:12.8px"
target="_blank">https://www.postgresql.org/me<wbr/>ssage-id/E1VYMqi-0001P4-P4%40w<wbr />rigleys.postgresql.org</a><span
style="font-size:12.8px">)with pg_dumpall -g and then individual pg_dump, then it would be helpful to have this
patch.</span><brstyle="font-size:12.8px" /><div style="font-size:12.8px"><br /></div><div
style="font-size:12.8px"><spanstyle="font-size:12.8px">Regards,</span></div><div style="font-size:12.8px"><span
style="font-size:12.8px">RafiaSabih</span></div><div style="font-size:12.8px"><span
style="font-size:12.8px">EnterpriseDB:</span><spanstyle="color:rgb(80,0,80);font-size:12.8px">: </span><a
href="http://www.enterprisedb.com/"rel="noreferrer" style="font-size:12.8px" target="_blank">http://www.ente<wbr
/>rprisedb.com</a></div></div>