
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
==========================================================================



Thu, 25 Feb 1999 17:50:14 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
shouldn't pg_dumpall...
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

Thu, 25 Feb 1999 19:14:51 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] shouldn't pg_dumpall... 