"Evert Daman" <e.daman@xxxxxxxxxxxxxxxxxx> 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
