Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D9364634A35 for ; Tue, 17 Mar 2009 10:32:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 05580-02-2 for ; Tue, 17 Mar 2009 10:32:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id B39B1634944 for ; Tue, 17 Mar 2009 10:32:19 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 07972118DCF; Tue, 17 Mar 2009 09:32:16 -0400 (EDT) Date: Tue, 17 Mar 2009 09:32:16 -0400 From: Ray Stell To: adamr@informatyka.gdansk.pl Cc: "Lori, Giancarlo" , pgsql-admin@postgresql.org Subject: Re: Need help to restore database Message-ID: <20090317133216.GB11376@cns.vt.edu> References: <556F27B79E1523449D310FCABD94333001958C10@derum205.emea.corp.eds.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/188 X-Sequence-Number: 31688 On Tue, Mar 17, 2009 at 12:01:01PM +0100, adamr@informatyka.gdansk.pl wrote: > On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo" > wrote: > > the postmaster process run, but any command pg_dump, etc I try to > > execute failed. The system respond that there are not database in the > > system. Can anyone help us ? I'm no expert, the quiet from the pros is deafening to me. What does the postmaster log say when you start up? What is the exact error msg that you refer to as "there are not database in the system?" What does the \l meta-command say, anything like this: template1=# \l List of databases Name | Owner | Encoding -------------+---------+---------- postgres | pgadmin | UTF8 template0 | pgadmin | UTF8 template1 | pgadmin | UTF8 (3 rows)