Re: User privileges-verification required

"Nauman Naeem" <nauman(dot)naeem(at)gmail(dot)com> writes:
> I tried the single-user mode option and it worked, thanks! but, don't
> you people think that we should provide this privilege in multi-user
> mode as well.In accordence to my second point.

No. Restricting what a superuser can do is pointless --- he can always
manage to shoot himself in the foot if he tries hard enough. (Consider
eg "DELETE FROM pg_authid".) Trying to fix it in the reverse direction
(re-establishing superuser after the last one's been deleted) has
obvious security issues.

The problem comes up sufficiently seldom that the single-user-mode
backdoor seems sufficient.

regards, tom lane