Re: Big problem

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