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
Import Notes
Reply to msg id not found: YourmessageofThu25Feb1999175014-0500XFMail.990225175014.vev@michvhf.com | Resolved by subject fallback