> 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
