X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 08D8111F677C for ; Fri, 7 Apr 2006 19:00:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18300-09 for ; Fri, 7 Apr 2006 19:00:27 -0300 (ADT) X-Greylist: delayed 00:29:26.086596 by SQLgrey- Received: from smtp04.wanadoo.nl (smtp04.wanadoo.nl [194.134.35.144]) by postgresql.org (Postfix) with ESMTP id CAC0F11F676D for ; Fri, 7 Apr 2006 19:00:29 -0300 (ADT) Received: from beneden (s559361db.adsl.wanadoo.nl [85.147.97.219]) by smtp4.wanadoo.nl (Postfix) with SMTP id 5C9C641798; Fri, 7 Apr 2006 23:31:00 +0200 (CEST) Message-ID: <005401c65a8a$908e2820$0b01a8c0@beneden> From: "Evert Daman" To: "Tom Lane" Cc: References: <002801c654b4$816eb340$91512b0a@B100> <15203.1144435171@sss.pgh.pa.us> Subject: Re: database owner gone? Date: Fri, 7 Apr 2006 23:31:00 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200604/92 X-Sequence-Number: 21261 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" To: "Evert Daman" Cc: Sent: Friday, April 07, 2006 8:39 PM Subject: Re: [ADMIN] database owner gone? > "Evert Daman" 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 > >