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: BANLkTinb5jo2CoKHnTDBC3AsbTUtCVm=sw@mail.gmail.com (view raw or flat)
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:
<http://www.postgresql.org/docs/9.0/static/app-postgres.html>
and from there you can fix your superuser privileges.

Josh

In response to

Responses

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-2014 The PostgreSQL Global Development Group