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