On Monday 01 March 2010 @ 17:58, Tom Lane wrote: > "Ed L." <pgsql@xxxxxxxxxxxxx> writes: > > Killed the stuck postmaster with sigkill, edited the file, > > restarted postmaster, and it re-wrote the file with the > > bogus entry. I don't have any superuser sessions open. Is > > there another route? > > What you're going to need to do is stop the postmaster, start > a standalone backend (see the "postgres" man page entry if you > never did that before) and issue the ALTER USER in the > standalone backend. Then you can restart normal operations. That did the trick. Thank you very much, Sensei. Ed -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
