Re: Read data from WAL

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