By mistake I took away superuser rights from my postgresql Admin. Any idea
how to get it back? There is no other superuser in the database.
----
R.Hnat




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reinhard Hnat wrote:
How did you remove it?
Maybe pg_hba.conf is what you're looking for.
Or the pg_shadow table for passwords etc.

hth
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"Reinhard Hnat" <hnat (AT) logotronic (DOT) co.at> writes:
Assuming you are running a reasonably recent Postgres (I am sure this
works in 7.3, don't recall about 7.2 or before):

1. Stop the postmaster.
2. Start a standalone backend (see the "postgres" man page for details).
3. Now you are effectively superuser. ALTER USER to give your admin
back superuserness, or just UPDATE his pg_shadow row if that seems
easier.
4. Stop standalone backend, restart postmaster.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster