Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id EFF466358B5 for ; Tue, 17 Mar 2009 10:19:07 -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 01356-04-6 for ; Tue, 17 Mar 2009 10:18:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by mail.postgresql.org (Postfix) with ESMTP id A2BC0635821 for ; Tue, 17 Mar 2009 10:18:59 -0300 (ADT) Received: from perhan.alvh.no-ip.org (200-126-101-194.bk7-dsl.surnet.cl [200.126.101.194]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id n2HDPaXb026012 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 17 Mar 2009 06:25:39 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id AF50047CE0; Tue, 17 Mar 2009 09:18:50 -0400 (CLT) Date: Tue, 17 Mar 2009 09:18:50 -0400 From: Alvaro Herrera To: "Lori, Giancarlo" Cc: pgsql-admin@postgresql.org Subject: Re: Need help to restore database Message-ID: <20090317131850.GB4202@alvh.no-ip.org> References: <556F27B79E1523449D310FCABD94333001958C10@derum205.emea.corp.eds.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <556F27B79E1523449D310FCABD94333001958C10@derum205.emea.corp.eds.com> User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 17 Mar 2009 06:25:40 -0700 (PDT) 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/186 X-Sequence-Number: 31686 Lori, Giancarlo wrote: > A client system based on pgsql is down because the database raise an > error message like " no left space on device". We have deleted some log > files on this machine and after a system restart the db (and the system) > was up&running. After two days the database has crashed again. Looking > the postgres log there was an error on xlog file (I have inspected the > directory pg_xlog and no files I found it). I'll try to re-build the > xlog file with pg_resetxlog. The utilities has created a new xlog file, > 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. Looks like somebody deleted critical files to get some space back. > Can anyone help us ? Find the most recent backup ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.