From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: alban <alban_dot_minassian_@wanadoo.fr>
Cc: pgsql-sql@postgresql.org
Subject: Re: 7.3 : how add user when last user have lost 'createuser' option
Date: Sat, 08 Nov 2003 16:15:03 -0500
Message-ID: <14692.1068326103@sss.pgh.pa.us> (raw)
In-Reply-To: <200311082103.hA8L3Fe20121@candle.pha.pa.us>
References: <200311082103.hA8L3Fe20121@candle.pha.pa.us>
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> alban wrote:
>> i have execute
>> ALTER USER postgres WITH NOCREATEUSER;
> Uh, you removed createuser permission from the postgres super-user.
That was a really bad move :-(
If you have no superusers left, I think your only option is to shut down
the postmaster, start a standalone backend, and ALTER USER postgres back
to superuser status in the standalone backend. Then you can restart the
postmaster.
IIRC this will work in 7.3 and probably 7.2. If you're running
something older, you are well and truly hosed, because you can't
reclaim superuser status even with a standalone backend.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us, alban_dot_minassian_@wanadoo.fr
Subject: Re: 7.3 : how add user when last user have lost 'createuser' option
In-Reply-To: <14692.1068326103@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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