| From: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> |
|---|---|
| To: | Baldur Þór Emilsson <baldur(at)baldur(dot)biz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Read data from WAL |
| Date: | 2013-07-15 12:59:56 |
| Message-ID: | CAEYLb_VbN-r5dLha-64=bHkSWqRu1R3yLs1euH=DTuAJuePqXg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 15, 2013 at 1:45 PM, Baldur Þór Emilsson <baldur(at)baldur(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haiming Zhang | 2013-07-15 13:08:41 | Re: Update big table |
| Previous Message | Satoshi Nagayasu | 2013-07-15 12:58:51 | Re: Read data from WAL |