On Thu, 04 Sep 2003, Tom Lane wrote: > Ben Grimm <[EMAIL PROTECTED]> writes: > > I haven't tried the 7.4 beta, so it may be fixed there - but in > > 7.3.4, pg_dumpall doesn't output global database ACL's. > > This is fixed for 7.4.
Is there a patch to backport this to the 7.3 series? Without it there is no reliable way to backup a database with more complicated permissions. I'm sure I'd just muddle through with a sed script to insert the grants at the right place should the need arise. But likewise - with the other bug I reported - pg_dump is generating sql that can't be executed because the users don't have permissions. The resulting SQL just won't work as is... and without intervention users can't restore/upgrade databases that have these types of permissions. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
