pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgre suoer
2+ messages / 2 participants
[nested] [flat]

* postgre suoer
@ 2008-02-25 12:59  nabakumar salam <salamnabakumar@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: nabakumar salam @ 2008-02-25 12:59 UTC (permalink / raw)
  To: pgsql-admin

I have a single user role configured for my postgre database 8.2
The user is a super user.
I opened the property window of this user and deselect the super user check
box.
It gave me a warning. I select OK.
I was expecting that it would not allow removing that super user rights as
it is the only super user in my DB.

now my database is without any user  with super user rights.
How do I create one now or get back the previous super user?
Can anybody give me some pointers??

Thanks in advance,
Naba

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: postgre suoer
@ 2008-02-25 15:41  Tom Lane <tgl@sss.pgh.pa.us>
  parent: nabakumar salam <salamnabakumar@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-02-25 15:41 UTC (permalink / raw)
  To: nabakumar salam <salamnabakumar@gmail.com>; +Cc: pgsql-admin

"nabakumar salam" <salamnabakumar@gmail.com> writes:
> I was expecting that it would not allow removing that super user rights as
> it is the only super user in my DB.

Superusers are assumed to be careful enough not to shoot themselves in
the foot like that.  I suggest not experimenting with things like
"delete from pg_proc;" either ;-)

> now my database is without any user  with super user rights.
> How do I create one now or get back the previous super user?

Shut down the postmaster, start a standalone backend, create a superuser
using CREATE USER, restart the postmaster.  You're always super inside
a standalone backend.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-02-25 15:41 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-25 12:59 postgre suoer nabakumar salam <salamnabakumar@gmail.com>
2008-02-25 15:41 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox