Skip site navigation (1) Skip section navigation (2)

Re: Superuser accout (PostgreSQL 9.0.4)

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Superuser accout (PostgreSQL 9.0.4)
Date: 2011-04-08 03:29:22
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
On Thu, Apr 7, 2011 at 11:15 PM, Grzegorz Szpetkowski
<gszpetkowski(at)gmail(dot)com> wrote:
> Is there any way to restore superuser without recreating cluster from
> scratch (initdb, pg_createcluster etc.) ? Or better should PostgreSQL
> prevent for such situation (mistake command) ? I don't know is there
> any "at least one superuser per cluster rule" (?)

I think you should be able to start Postgres in single-user mode, see:
and from there you can fix your superuser privileges.


In response to


pgsql-novice by date

Next:From: AndrejDate: 2011-04-08 03:34:08
Subject: Re: Superuser accout (PostgreSQL 9.0.4)
Previous:From: Grzegorz SzpetkowskiDate: 2011-04-08 03:21:00
Subject: Valid role name (PostgreSQL 9.0.4)

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group