Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> A guy on the IRC channel managed to accidentally click the wrong thing
> in phpPgAdmin and managed to remove superuser privileges from his only
> superuser.
No sweat; we've seen this one before.
Stop postmaster and start a standalone backend. Now you are a
superuser, and you can create a new superuser, or just go in and UPDATE
pg_shadow to make your original user super again. Exit standalone
backend, restart postmaster, have a beer.
The REINDEX man page is worth reading if you've never used a standalone
backend before; it covers some of the gory details.
regards, tom lane
