it was postgresql version 7.3.10 and we recovered access by dumping and recreating (new initdb) the database. everything is allright now. we had never used the vacuum before (database was up for about two months). after doing that too things were speeding up again. but that couldn't be the cause of the lost user could it? ----- Original Message ----- From: "Tom Lane" <tgl@xxxxxxxxxxxxx> To: "Evert Daman" <e.daman@xxxxxxxxxxxxxxxxxx> Cc: <pgsql-admin@xxxxxxxxxxxxxx> Sent: Friday, April 07, 2006 8:39 PM Subject: Re: [ADMIN] database owner gone? > "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 > >
