Re: Help: Dumb newbie locked himself out! - Mailing list pgsql-novice

"Balazs Wellisch" <balazs@bwellisch.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