Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group