Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BC5C49FB2BD for ; Wed, 25 Oct 2006 05:05:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 08196-02 for ; Wed, 25 Oct 2006 05:05:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from dns.ricordatasystem.int (host10-241-static.73-81-b.business.telecomitalia.it [81.73.241.10]) by postgresql.org (Postfix) with SMTP id BCD2D9FB2BA for ; Wed, 25 Oct 2006 05:05:25 -0300 (ADT) Received: (qmail 83004 invoked by uid 1013); 25 Oct 2006 08:44:46 -0000 Received: from unknown (HELO mypc.ricordatasystem.info) (192.168.2.11) by dns.ricordatasystem.int with SMTP; 25 Oct 2006 08:44:46 -0000 Date: Wed, 25 Oct 2006 10:09:49 +0200 From: Enrico To: pgsql-admin@postgresql.org Subject: Re: database "postgres" does not exist Message-ID: <20061025100949.061d42e2@mypc.ricordatasystem.info> In-Reply-To: <453E41D4.5010408@toulouse.inra.fr> References: <453E41D4.5010408@toulouse.inra.fr> X-Mailer: Sylpheed-Claws 1.0.4 (GTK+ 1.2.10; i386-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/158 X-Sequence-Number: 23461 On Tue, 24 Oct 2006 18:39:48 +0200 Emmanuel Courcelle wrote: > when I try to use psql like this: > sudo -u postgres psql > I get the message: > psql: FATAL: database "postgres" does not exist Are you sure that postgres database really exists? Try psql dbname -U postgres Bye Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!! scotty@linuxtime.it - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi