X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AD3FADAE37 for ; Tue, 25 Oct 2005 17:33:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15509-01 for ; Tue, 25 Oct 2005 20:33:05 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 5CE8EDAD24 for ; Tue, 25 Oct 2005 17:33:06 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 25 Oct 2005 17:35:06 -0300 X-IronPort-AV: i="3.97,250,1125892800"; d="scan'208"; a="19696457:sNHT37764290" Received: from alvh.no-ip.org (200.85.220.75) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4350159700158A61; Tue, 25 Oct 2005 17:33:07 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 1654AC2D469; Tue, 25 Oct 2005 17:33:45 -0300 (CLST) Date: Tue, 25 Oct 2005 17:33:45 -0300 From: Alvaro Herrera To: Jeff Frost Cc: Bruno Wolff III , pgsql-admin@postgresql.org Subject: Re: Replaying archived wal files after a dump restore? Message-ID: <20051025203344.GB7836@surnet.cl> Mail-Followup-To: Jeff Frost , Bruno Wolff III , pgsql-admin@postgresql.org References: <43407865.7090706@pse-consulting.de> <20051003052744.GF4490@fetter.org> <20051025030951.GA16642@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.059 required=5 tests=[AWL=-0.717, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200510/267 X-Sequence-Number: 19339 Jeff Frost wrote: > Unfortunately, diffing the 8.0.4 docs against the 8.1 docs shows almost no > useful differences. I was mostly hoping someone with knowledge of the WAL > internal format could tell me how to extract the transactions from some and > manually replay them in the db via psql with lots of copy/paste action. Oh, so the data in the log must be very valuable to you. I guess you could extract the data if you processed the WAL logs. A tool to do this doesn't exist as far as I know, but you could write your own. There was a crude hack by Tom Lane, which you can find on the archives: From: Tom Lane To: "Mohan, Ross" Cc: pgsql-admin@postgresql.org Date: Wed, 13 Apr 2005 10:26:09 -0400 Subject: Re: [ADMIN] question about wal and point in time recovery It would be nice to expand on this tool. -- Alvaro Herrera http://www.PlanetPostgreSQL.org "Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"