Lists: | pgsql-hackers |
---|
From: | higepon <higepon(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | WAL dump tool |
Date: | 2009-05-08 08:43:11 |
Message-ID: | f07386410905080143q66f5e87dtcf7f8545578f5d56@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hi.
Is the following todo item still necessary?
Create dump tool for write-ahead logs for use in determining
transaction id for point-in-time recovery.
This is useful for checking PITR recovery.
If so, I want to make it.
What is the expected output of the dump tool?
TransactionId, TimeLineID and ?
Best regards,
-----
MINOWA Taro (Higepon)
Cybozu Labs, Inc.
From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | higepon <higepon(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: WAL dump tool |
Date: | 2009-05-09 04:20:43 |
Message-ID: | 3073cc9b0905082120j7f67ca9eu50deaa2eb0b9934@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Fri, May 8, 2009 at 3:43 AM, higepon <higepon(at)gmail(dot)com> wrote:
> Hi.
> Is the following todo item still necessary?
>
> Create dump tool for write-ahead logs for use in determining
> transaction id for point-in-time recovery.
> This is useful for checking PITR recovery.
>
> If so, I want to make it.
> What is the expected output of the dump tool?
> TransactionId, TimeLineID and ?
>
don't know if this project ever works
http://pgfoundry.org/projects/xlogviewer but seems like is a start (it
was made for 8.2 so you will have to adjust for 8.3 or even better
8.4)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, higepon <higepon(at)gmail(dot)com> |
Subject: | Re: WAL dump tool |
Date: | 2009-05-10 05:23:44 |
Message-ID: | 200905100123.44605.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Saturday 09 May 2009 00:20:43 Jaime Casanova wrote:
> On Fri, May 8, 2009 at 3:43 AM, higepon <higepon(at)gmail(dot)com> wrote:
> > Hi.
> > Is the following todo item still necessary?
> >
> > Create dump tool for write-ahead logs for use in determining
> > transaction id for point-in-time recovery.
> > This is useful for checking PITR recovery.
> >
> > If so, I want to make it.
> > What is the expected output of the dump tool?
> > TransactionId, TimeLineID and ?
>
> don't know if this project ever works
> http://pgfoundry.org/projects/xlogviewer but seems like is a start (it
> was made for 8.2 so you will have to adjust for 8.3 or even better
> 8.4)
>
>
It did work at one point. We used it for some disaster recovery work maybe a
year or so ago. We had to update it for 8.3, and remove some linuxisms to get
it to compile for Solaris. I think it might have still had issues actually
dumping data, but it did do a good job at finding corrupted xlogs. istr Theo
submitted a patch, but I think the author had abandoned it. Personally I'd
love to see it moved into postgresql proper (and get the cleaning/updating
that implies).
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
From: | Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, higepon <higepon(at)gmail(dot)com>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Subject: | Re: WAL dump tool |
Date: | 2009-05-18 04:45:18 |
Message-ID: | a55915760905172145i6d91347dh3903cbfdbc95157a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Sun, May 10, 2009 at 12:23 AM, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)net> wrote:
> On Saturday 09 May 2009 00:20:43 Jaime Casanova wrote:
>> On Fri, May 8, 2009 at 3:43 AM, higepon <higepon(at)gmail(dot)com> wrote:
>> > Hi.
>> > Is the following todo item still necessary?
>> >
>> > Create dump tool for write-ahead logs for use in determining
>> > transaction id for point-in-time recovery.
>> > This is useful for checking PITR recovery.
>> >
>> > If so, I want to make it.
>> > What is the expected output of the dump tool?
>> > TransactionId, TimeLineID and ?
>>
>> don't know if this project ever works
>> http://pgfoundry.org/projects/xlogviewer but seems like is a start (it
>> was made for 8.2 so you will have to adjust for 8.3 or even better
>> 8.4)
>
> It did work at one point. We used it for some disaster recovery work maybe a
> year or so ago. We had to update it for 8.3, and remove some linuxisms to get
> it to compile for Solaris. I think it might have still had issues actually
> dumping data, but it did do a good job at finding corrupted xlogs. istr Theo
> submitted a patch, but I think the author had abandoned it. Personally I'd
> love to see it moved into postgresql proper (and get the cleaning/updating
> that implies).
Would this allow functionality similar to that of LogMiner (
http://www.oracle.com/technology/deploy/availability/htdocs/LogMinerOverview.htm
), or is it something else entirely?