Re: WAL files format

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: mito <milos(dot)orszag(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL files format
Date: 2008-04-20 17:20:29
Message-ID: 36e682920804201020m5179ec6ah4c3795b5d6330da3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 Miloš Ország 2008-04-20 17:55:35 Re: WAL files format
Previous Message Magnus Hagander 2008-04-20 17:16:55 Re: TODO, FAQs to Wiki?