Re: Read data from WAL

On Mon, Jul 15, 2013 at 1:45 PM, Baldur Þór Emilsson <baldur@baldur.biz> wrote:
> Are there any projects or standard procedures for reading the data from the
> WAL to get a change log for the database (or without the WAL, using some
> other method)? I have searched for information about this quite thoroughly
> without luck, so I thought I'd try asking here before I started to patch
> Postgres :)

I think that pg_xlogdump is what you're looking for:

http://www.postgresql.org/docs/9.3/static/pgxlogdump.html

It only became available with Postgres 9.3. On prior versions, you can use:

https://github.com/snaga/xlogdump

--
Regards,
Peter Geoghegan