Re: WAL files format

From: mito <milos(dot)orszag(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL files format
Date: 2008-04-20 19:56:50
Message-ID: 480BA002.4010905@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

What information are currently strored in WAL sequence ?

Jonah H. Harris wrote:
> xlog.c :)
>
> On Sun, Apr 20, 2008 at 1:55 PM, Miloš Ország <milos(dot)orszag(at)gmail(dot)com> wrote:
>
>> Is there any document describing WAL file format?
>>
>>
>>
>>
>> On Sun, Apr 20, 2008 at 7:20 PM, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com>
>> wrote:
>>
>>
>>> See xlogdump and xlogviewer.
>>>
>>>
>>>
>>>
>>> On Sun, Apr 20, 2008 at 7:44 AM, mito <milos(dot)orszag(at)gmail(dot)com> wrote:
>>>
>>>> Hi,
>>>>
>>>> iam developing version control system based on content because i havent
>>>> found anything for postgres and it sounds like great tool to have.
>>>>
>> Propably
>>
>>>> i will use Rules and Views with shadow tables, but iam interested in
>>>> alternative to examine WAL files.
>>>>
>>>> So iam interested in WAL file format and information that can be
>>>>
>> extracted
>>
>>>> from it. Is there any way to build some API above WAL file to be able to
>>>> analyze data changes in time caused by DML ? Iam aware of xlog.c but not
>>>>
>> of
>>
>>>> its capabilities and features, its kind of hard for me to analyze that
>>>>
>> file.
>>
>>>> MS SQL create transaction logs and there are tools like ApexSQL Log
>>>>
>> that
>>
>>>> can analyze logs a redo changes made by DML. So i thought it would by
>>>>
>> great
>>
>>>> to have such tools for opensource system like postgres.
>>>>
>>>> Also, if anybody has any ideas or alternatives on content version
>>>>
>> control
>>
>>>> system i will be realy thankfull.
>>>>
>>>> Thanks Milos
>>>>
>>>> --
>>>> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgsql-hackers
>>>>
>>>>
>>>
>>> --
>>> Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
>>> EnterpriseDB Corporation | fax: 732.331.1301
>>> 499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
>>> Edison, NJ 08837 | http://www.enterprisedb.com/
>>>
>>>
>>
>
>
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2008-04-20 21:01:26 log_filename()
Previous Message Joshua D. Drake 2008-04-20 18:46:49 Re: get rid of psql welcome message