Re: [GENERAL] Read data from WAL

2013-08-09 Thread Andres Freund
On 2013-07-15 13:34:01 +, 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

Re: [GENERAL] Read data from WAL

2013-08-08 Thread Bruce Momjian
On Mon, Jul 15, 2013 at 01:34:01PM +, 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

[GENERAL] Read data from WAL

2013-07-15 Thread Baldur Þór Emilsson
I have been looking into the WAL to know if there is any way to read the data contained in it. I know that it stores binary data that is applied directly to the files in the Postgres cluster. I would like to get the real data, like it is written in the SQL queries, instead of the binary data. Are

Re: [GENERAL] Read data from WAL

2013-07-15 Thread Satoshi Nagayasu
Hi, 2013/07/15 21:45, Baldur Þór Emilsson 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

Re: [GENERAL] Read data from WAL

2013-07-15 Thread Peter Geoghegan
On Mon, Jul 15, 2013 at 1:45 PM, Baldur Þór Emilsson bal...@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

Re: [GENERAL] Read data from WAL

2013-07-15 Thread Baldur Þór Emilsson
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