alter superuser...
Hi, List!
I alter user postgres, that was a superuser in my db cluster. And now it is
not a superuser. There are no superusers in my cluster. Yes, I am stupid :)
But are there any abilities to restore superuser excluding initdb?
Sergey Karin
On Wed, Feb 08, 2006 at 10:42:41AM +0300, Sergey Karin wrote:
Hi, List!
I alter user postgres, that was a superuser in my db cluster. And now it is
not a superuser. There are no superusers in my cluster. Yes, I am stupid :)But are there any abilities to restore superuser excluding initdb?
You can try running in standalone mode. Check the docs, but it amounts
to shutting down the postmaster and running postgres directly. No
multiline queries, no query editing but you are superuser and can fix
stuff up.
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.