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 B46CC11F68F7 for ; Fri, 31 Mar 2006 07:16:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91666-01 for ; Fri, 31 Mar 2006 07:16:05 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7458D11F68DA for ; Fri, 31 Mar 2006 07:16:03 -0400 (AST) Received: from mailservice.tudelft.nl (mailservice.tudelft.nl [130.161.131.5]) by svr4.postgresql.org (Postfix) with ESMTP id E66BB5AF068 for ; Fri, 31 Mar 2006 11:16:03 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by rav.antivirus (Postfix) with ESMTP id D89A822F01C for ; Fri, 31 Mar 2006 13:15:59 +0200 (CEST) Received: from smtp-a.tudelft.nl (smtp-a.tudelft.nl [130.161.129.18]) by mx1.tudelft.nl (Postfix) with ESMTP id 7FF8722EF7F for ; Fri, 31 Mar 2006 13:15:59 +0200 (CEST) Received: from B100 (cable-175-135.zeelandnet.nl [82.176.175.135]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by smtp-a.tudelft.nl (Postfix) with ESMTP id 671DBF1A37 for ; Fri, 31 Mar 2006 13:15:59 +0200 (CEST) Message-ID: <002801c654b4$816eb340$91512b0a@B100> From: "Evert Daman" To: Subject: database owner gone? Date: Fri, 31 Mar 2006 13:16:06 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C654C5.44BA5330" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Virus-Scanned: by amavisd-new at tudelft.nl X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200604/71 X-Sequence-Number: 21240 This is a multi-part message in MIME format. ------=_NextPart_000_0025_01C654C5.44BA5330 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable we have a problem here at a large database using postgresql. i used it with no problems yesterday and suddenly today all the databases were no longer visible in phppgadmin. using pgsql -U admin does give me access. so i thought something was wrong with the usersettings. checking these settings with \d reveales that the table no longer had an owner. 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? thanx for any help, Evert ------=_NextPart_000_0025_01C654C5.44BA5330 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
we have a problem here at a large = database using=20 postgresql.
i used it with no problems yesterday = and suddenly=20 today all
the databases were no longer visible in = phppgadmin.
 
using pgsql -U admin <database> = does give me=20 access.
so i thought something was wrong with = the=20 usersettings. checking
these settings with \d reveales that = the table no=20 longer had
an owner.
 
select * from pg_user gives me only 1 = user=20 (postgres). pg_shadow
also gives 1 user. so i tried = recreating the admin=20 user with
createuser admin (as postgres user) but = that failed=20 saying admin
allready exists! so where is it now? = and how do i=20 get access
back to my database using pg_dump and=20 phppgadmin?
 
thanx for any help,
Evert
 
 
------=_NextPart_000_0025_01C654C5.44BA5330--