| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Sergey Karin <sergey(dot)karin(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: alter superuser... |
| Date: | 2006-02-08 09:30:33 |
| Message-ID: | 20060208093033.GB1985@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)org> http://svana.org/kleptog/
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | surabhi.ahuja | 2006-02-08 09:44:56 | loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index" |
| Previous Message | Martijn van Oosterhout | 2006-02-08 09:28:17 | Re: futex lockup? |