Ð ÐÐÐ, 24.05.2004, Ð 16:12, Tom Lane ÐÐÑÐÑ: > Christopher Kings-Lynne <[EMAIL PROTECTED]> 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 question whether we should prevent this from happening stands; I think we should. -- Markus Bertheau <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org