Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 067399FB3F8 for ; Tue, 24 Oct 2006 13:39:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 49950-10 for ; Tue, 24 Oct 2006 16:39:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6E3469FB3A8 for ; Tue, 24 Oct 2006 13:39:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from pastel.toulouse.inra.fr (pastel.toulouse.inra.fr [147.99.111.242]) by svr4.postgresql.org (Postfix) with ESMTP id 96D615AF881 for ; Tue, 24 Oct 2006 16:39:48 +0000 (GMT) Received: from [147.99.102.209] (lipmCEC [147.99.102.209]) by pastel.toulouse.inra.fr (/8.13.7) with ESMTP id k9OGdfCD002375 for ; Tue, 24 Oct 2006 18:39:41 +0200 (MEST) Message-ID: <453E41D4.5010408@toulouse.inra.fr> Date: Tue, 24 Oct 2006 18:39:48 +0200 From: Emmanuel Courcelle User-Agent: Thunderbird 1.5.0.5 (X11/20060719) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: database "postgres" does not exist Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-1.6 (pastel.toulouse.inra.fr [147.99.111.242]); Tue, 24 Oct 2006 18:39:41 +0200 (MEST) X-j-chkmail-Score: MSGID : 453E41CD.000 on pastel : j-chkmail score : X : 5/50 0 X-Miltered: at pastel with ID 453E41CD.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on pastel X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/152 X-Sequence-Number: 23455 Hello everybody We have a very strange problem here: we have been using postgresql for several years now, it runs fine without any problem. BUT today, we saw something I do not understand: when I try to use psql like this: sudo -u postgres psql I get the message: psql: FATAL: database "postgres" does not exist About 1-2 months ago, this was OK I know this message is current on a new installation when the system is NOT initialized. But what puzzles me here is that the database postgres DID exist... but it seems to have suddenly disappeared !!!! A part from this, everything works fine, for example the command: sudo -u postgres psql -d template1 works, and the postgres applications run quite smoothly So, here is my question: how such a thing could have happen ? We cannot remeber any stupid thing we could have done (but may be we did... And what do I have to do to recreate the postgres database... in fact, is it even necessary doing so ? The OS is a 64bits Debian (distribution testing, dist-upgraded today but this did not correct the problem) The postgres version is 8.1.4 Thanks in advance, -- Emmanuel COURCELLE emmanuel.courcelle@toulouse.inra.fr L.I.P.M. (UMR CNRS-INRA 2594/441) tel (33) 5-61-28-54-50 B.P.52627 - 31326 CASTANET TOLOSAN Cedex - FRANCE ------