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

Regaining superuser access

From: Bernt Drange <badrange(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Regaining superuser access
Date: 2008-09-18 11:13:08
Message-ID: 355ba921-203b-4380-bee4-67209316be62@x35g2000hsb.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
I have a user with a problem on his PostgreSQL 8.1 server running
Windows:

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?

I can log on to the database with other users, but even if I add
"trust" to pg_hba.conf PostgreSQL will not let me access the database
as the superuser.

I have remote access to the server, which is now on a ship outside of
Madagascar.

The problem we have seems to be the same as this user reports (but got
no reply):
http://www.nabble.com/Fatal-error%3A-role-%22postgres%22-no-login%21-tp14537100p14541715.html

I have looked in the documentation, but don't seem to be able to find
any solutions. Pointers are welcome!

Kind regards,
Bernt

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2008-09-18 11:15:13
Subject: Re: Adding new flags to XLogRecord
Previous:From: Heikki LinnakangasDate: 2008-09-18 11:02:15
Subject: Re: [HACKERS] 0x1A in control file on Windows

pgsql-admin by date

Next:From: Glyn AstillDate: 2008-09-18 12:35:30
Subject: Re: Regaining superuser access
Previous:From: Julius TuskenisDate: 2008-09-18 09:19:13
Subject: CVS for postgresql

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