From: Glyn Astill <glynastill@yahoo.co.uk>
To: pgsql-admin@postgresql.org, Bernt Drange <badrange@gmail.com>
Subject: Re: Regaining superuser access
Date: Thu, 18 Sep 2008 12:35:30 +0000 (GMT)
Message-ID: <497334.45125.qm@web25803.mail.ukl.yahoo.com> (raw)
In-Reply-To: <355ba921-203b-4380-bee4-67209316be62@x35g2000hsb.googlegroups.com>
> The server only has one superuser, and for some reason he
> decided to
> remove the logon privilege on this user in PgAdmin III. So
> now he has
> lost superuser access to the database server.
>
> Is there some way to override this setting? Or some way to
> trick
> PostgreSQL into creating a new superuser without superuser
> access?
Start it up in single user mode?
http://www.postgresql.org/docs/8.3/static/app-postgres.html
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-admin@postgresql.org
Cc: glynastill@yahoo.co.uk, badrange@gmail.com
Subject: Re: Regaining superuser access
In-Reply-To: <497334.45125.qm@web25803.mail.ukl.yahoo.com>
* 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