X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B73DB9FBC27 for ; Fri, 25 Aug 2006 15:31:04 -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 44429-02 for ; Fri, 25 Aug 2006 18:31:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 655E19FBC29 for ; Fri, 25 Aug 2006 15:31:03 -0300 (ADT) Received: (qmail invoked by alias); 25 Aug 2006 18:31:02 -0000 Received: from dslb-084-063-006-253.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.6.253] by mail.gmx.net (mp029) with SMTP; 25 Aug 2006 20:31:02 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: 7.4 - data recovery Date: Fri, 25 Aug 2006 20:31:00 +0200 User-Agent: KMail/1.9.3 Cc: "Bartosz Belter" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608252031.00864.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/292 X-Sequence-Number: 22835 Bartosz Belter wrote: > 3. I've recovered some files and it looks to me they're from > $PGDATA/base/data/xxx (it looks this is the complete folder) > 4. No other files! (no pg_clog, pg_xlog etc) If you don't have a clog, then all your transactions will appear as "didn't happen yet", so your table data appears to be in the future. You can just commit dummy transactions until it appears again. This is obvious not an official and approved way, but it's at least a shot before you're forced to get out your hex editor. -- Peter Eisentraut http://developer.postgresql.org/~petere/