On Sep 18, 2:35 pm, glynast...@xxxxxxxxxxx (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 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 Thanks a bunch! 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 reason -D didn't work, but SET PGDATA=xxx worked), I finally managed to fix my problem. You saved my user's day (of course *I* would never do something that stupid)! Bernt
