Обсуждение: shouldn't pg_dumpall...

Shouldn't pg_dumpall also dump user privileges?  Every time I've updated
(just did it a little while ago) I have to go back into the databases and
grant all the users their privileges.  Or am I doing something wrong?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null      # include <std/disclaimers.h>
       TEAM-OS2       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================

Vince Vielhaber <vev@michvhf.com> writes:
> Shouldn't pg_dumpall also dump user privileges?

I believe pg_dumpall -z does it right.  That's what I usually use.

I suggested making -z the default a while ago, but no one has gotten
around to doing something about it.  (It'd be easy enough, but tedious,
since you'd need to invent a new switch for turning off privilege-
dumping and then update all the documentation.  Sigh.)
        regards, tom lane