"Balazs Wellisch" <balazs(at)bwellisch(dot)com> writes:
> UPDATE pg_shadow SET usesuper = true WHERE usename = 'postgres';
> ERROR: pg_shadow: Permission denied.
Hmm. I forgot that you'd need usecatupd privilege to do that.
> Any other suggestions? I appreciate your help.
I think you may be stuck :-( ... unless you want to risk editing the
pg_shadow file with a binary-file editor.
regards, tom lane