Re: [ADMIN] Regaining superuser access

2008-09-19 Thread Bernt Drange
On Sep 18, 7:03 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > Bernt Drange escribió: > > > After a lot of fiddling with being able to enter single user mode on a > > windows machine (I had to figure out how to run the command line as > > the correct user, then for some re

Re: [ADMIN] Regaining superuser access

2008-09-18 Thread Bernt Drange
On Sep 18, 2:35 pm, [EMAIL PROTECTED] (Glyn Astill) wrote: > > 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

[ADMIN] Regaining superuser access

2008-09-18 Thread Bernt Drange
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 se