SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:59 AM
| ||||
| ||||
 Re: database owner gone? "Evert Daman" <e.daman@student.tudelft.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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
|
04-10-2008, 05:59 AM
| |||
| |||
| Re: database owner gone? "Evert Daman" <e.daman@wanadoo.nl> writes: > 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? It could be, if you'd managed to execute 2 billion transactions in two months ... which seems a bit implausible. But in any case, please read the documentation about required routine maintenance. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-10-2008, 06:00 AM
| ||||
| ||||
| Re: database owner gone? 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@sss.pgh.pa.us> To: "Evert Daman" <e.daman@student.tudelft.nl> Cc: <pgsql-admin@postgresql.org> Sent: Friday, April 07, 2006 8:39 PM Subject: Re: [ADMIN] database owner gone? > "Evert Daman" <e.daman@student.tudelft.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 > > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
