Re: Regaining superuser access

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org, Bernt Drange <badrange(at)gmail(dot)com>
Subject: Re: Regaining superuser access
Date: 2008-09-18 12:35:30
Message-ID: 497334.45125.qm@web25803.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers


> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Randall Wilson 2008-09-18 15:29:28 Idle Error invalid byte sequence
Previous Message Bernt Drange 2008-09-18 11:13:08 Regaining superuser access

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-09-18 12:38:58 Re: Adding new flags to XLogRecord
Previous Message Simon Riggs 2008-09-18 12:18:00 Re: [PATCHES] Infrastructure changes for recovery