Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: ERROR: must be superuser to alter superusers
- From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: ERROR: must be superuser to alter superusers
- Date: Mon, 24 Sep 2007 07:40:05 -0500
On 9/24/07, Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> wrote: > Hi, > > I had the very bad idea of removing the "superuser" flag from the > "pgsql" role. Now each time I try to set it back, with: That's kind of the equivalent of locking your keys in the car... > Since there is no superuser in the database engine anymore, what option > do I have? You have two choices. 1: re-initdb your database, losing everything 2: start your db in single user mode. to start your db in single user mode, you need to su - to the postgres superuser, then issue the command postgres --single. From there you can then set a user back to being a superuser.
- References:
- ERROR: must be superuser to alter superusers
- From: Philippe Lang
- ERROR: must be superuser to alter superusers
- Prev by Date: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
- Next by Date: DELETE FROM pg_class
- Previous by thread: ERROR: must be superuser to alter superusers
- Next by thread: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
- Indexes: