"Evert Daman" <e(dot)daman(at)student(dot)tudelft(dot)nl> writes:
> select * from pg_user gives me only 1 user (postgres). pg_shadow
> also gives 1 user. so i tried recreating the admin user with
> createuser admin (as postgres user) but that failed saying admin
> allready exists! so where is it now? and how do i get access
> back to my database using pg_dump and phppgadmin?
What PG version is this? How long has it been since you vacuumed
pg_shadow, or the other catalogs for that matter?
regards, tom lane