Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 569D12E3836 for ; Thu, 6 Dec 2007 12:41:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69301-02 for ; Thu, 6 Dec 2007 12:41:43 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by postgresql.org (Postfix) with ESMTP id 817392E383E for ; Thu, 6 Dec 2007 12:41:42 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so745670waf for ; Thu, 06 Dec 2007 08:41:40 -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=nUxOnsMLSrJ0pyrfKuEgH3nIRl1pwSUnT5fZ0MI8WtI=; b=kiTnWFzy4REVKlreg9c8na9mjs8+9JGdvHHs0WqW2cpDNj1zbuMTiv3eIRzmRdgKn50s+z3JkYR2fhvaajouhJT7PzRfKePDNuSmCk3TKq3QW2qyqO2O/qdQ5A1TDKFkqbIrVDowCLd/6y3SSD3gls7B0BXO7wUd8vh59S2nuNo= 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=rBAmwIjw511TbMMuSSOC+zZzvtSVgIU7XI9LFY0DbBpzqChUFrGhoQWJutBeJX8O/nJ8sO2VgXllLtzHWv3XfE+4C94gquuBzPilYdTcozUp3cqvaEEsaHxIQHeyzhLechY+w/9ahv3lvIsSwh5XboKpP0eE6Bty5xUk2lPE9Es= Received: by 10.114.67.2 with SMTP id p2mr1935524waa.1196959300732; Thu, 06 Dec 2007 08:41:40 -0800 (PST) Received: by 10.114.53.7 with HTTP; Thu, 6 Dec 2007 08:41:40 -0800 (PST) Message-ID: Date: Thu, 6 Dec 2007 10:41:40 -0600 From: "Scott Marlowe" To: "Palle Girgensohn" Subject: Re: lost data, possible playback? Cc: pgsql-admin@postgresql.org, kudo@pingpong.net In-Reply-To: <9FD29C9B828B9182011BDDF5@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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/27 X-Sequence-Number: 27544 On Dec 6, 2007 10:24 AM, Palle Girgensohn wrote: > Hi! > > A user accidentally deleted some results (i.e. tuples in a postgresql > database) created this morning. > > I have pg_xlog from about 9 o'clock until now. I have a pg_dump from ab out > 3 o'clock this morning. > > The results where created from about nine o'clock until noon, when the user > accidentally removed the results. > > Would it be possible to replay the WAL logs and get the results from > pg_xlog + the dump? No. > Or from a file system snapshot as of now (five pm) + pg_xlog? No.