Re: Read data from WAL - Mailing list pgsql-general

From Andres Freund
Subject Re: Read data from WAL
Date
Msg-id 20130809141044.GO14729@alap2.anarazel.de
Whole thread Raw
In response to Re: Read data from WAL  (Baldur Þór Emilsson <baldur@baldur.biz>)
List pgsql-general
On 2013-07-15 13:34:01 +0000, Baldur Þór Emilsson wrote:
> Thank you all for your responses. I'm aware of xlogdump but I'm afraid it
> does not help me with readign the data in the WAL. It is mainly "for
> debugging or educational purposes" (citing the docs) and it outputs a lot
> of information about the WAL records but not the contents of them (e.g. it
> says where an INSERT wrote the data, but not what the data is). Please
> correct me if I'm mistaken.
>
> What I'm looking for is a way to read the data that is inserted into the
> database. I was hoping there was some known way of doing that to save me
> the time it takes to patch Postgres to do that.

There's an in-development project doing that... Submitted to the last
commitfests and all. Search for changeset extraction et al.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: plpgsql FOR LOOP CTE problem ?
Next
From: "ascot.moss@gmail.com"
Date:
Subject: Re: Recovery.conf and PITR by recovery_target_time