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 <tgl@xxxxxxxxxxxxx> To: "Mohan, Ross" <RMohan@xxxxxxxxxxx> Cc: pgsql-admin@xxxxxxxxxxxxxx Date: Wed, 13 Apr 2005 10:26:09 -0400 Subject: Re: 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?" ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
