Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B699E2E02C8 for ; Thu, 6 Dec 2007 13:51:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 27498-09 for ; Thu, 6 Dec 2007 13:51:20 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id E25E32E0131 for ; Thu, 6 Dec 2007 13:51:19 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so795471waf for ; Thu, 06 Dec 2007 09:51:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=YEcIeU3wkPMXQm3y684IGD3YQNXG8zENJyO/XCSrGbw=; b=nJlB0rM/U5Oq2Hk4UbRw7/8gUqxe1575UxVeLQ7QaQuG5Q8izS1VdLcHn4krL88mhyy1i0jKMU+RlwqZM3arFx8HO/7u0mMEwJvS1CcObuduAi93jmmGgUnmvC6FGMTfTvqJl35yEhjwawIGpjEEzSVz4a9wa1+yfZHsFy1QPhM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WHwPYlFZ+M7vDsKhGkjM5JHygg98GqzY+DXZKYQYS5vD/7giYSifJhkfT1KiyXuPoS+qVtx7In4lVu/WPpOMX7DTmY/LLlPf00UGsOfPx0x7iXhKIyRuUuTLLQBBE2yd2uAWjCQiRD0lQILnM2elj/40q4ienOGfIqAA4uYT+4c= Received: by 10.114.200.2 with SMTP id x2mr1354354waf.1196963478183; Thu, 06 Dec 2007 09:51:18 -0800 (PST) Received: by 10.114.53.7 with HTTP; Thu, 6 Dec 2007 09:51:17 -0800 (PST) Message-ID: Date: Thu, 6 Dec 2007 11:51:17 -0600 From: "Scott Marlowe" To: "Palle Girgensohn" Subject: Re: lost data, possible playback? Cc: pgsql-admin@postgresql.org, kudo@pingpong.net In-Reply-To: <85D0F2A88A4AA6956510A2AF@rambutan.pingpong.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9FD29C9B828B9182011BDDF5@rambutan.pingpong.net> <4B1BF9CA998264A329F566B6@rambutan.pingpong.net> <85D0F2A88A4AA6956510A2AF@rambutan.pingpong.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/32 X-Sequence-Number: 27549 On Dec 6, 2007 11:11 AM, Palle Girgensohn wrote: > > So, I *must* have an image of the entire database, and I *must* have all > > WAL files since the image snapshot was taken? > > Is the real reason for the negative answer that there is a "hole" in the > pg_xlogs from 3 am - 9 am? No, the problem is that you don't have a system image from before the problem occurred. You need a file system backup from before the delete occurred, and a set of logs from the time the file system backup occurred until the accidental delete occurred.