From: | Marc Millas <marc(dot)millas(at)mokadb(dot)com> |
---|---|
To: | Ganesh Korde <ganeshakorde(at)gmail(dot)com> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Extract transactions from wals ?? |
Date: | 2019-11-22 10:35:10 |
Message-ID: | CADX_1aaa37Ea=uS+Obcr34+jrs5JdoA1xp-98mgJ_PCiD117hw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes !
We are looking for something providing a functionnality similar to
Oracle's :-)
Through PITR or a tool or extension around wals.
Still, as wals are containing enough info for replication to work,
It should be possible to extract from wals a list of objects that have been
written, and elements about what was written.
OS files written and position should be enough to provide this.
Something ?
thanks,
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Fri, Nov 22, 2019 at 11:02 AM Ganesh Korde <ganeshakorde(at)gmail(dot)com>
wrote:
> I think he wants to see data from different tables at different timestamp
> (like flashback query in Oracle). As per my understanding question here is
> can PITR be done for specific table and for specific timestamp.
>
> On Fri, Nov 22, 2019 at 2:37 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
> wrote:
>
>> On Thu, 2019-11-21 at 17:35 +0100, Marc Millas wrote:
>> > I was writing select from ""table"" as a template. We have to do this
>> for a bunch of tables.
>> > So, to my understanding, what you suggest is to PITR up to the first
>> timestamp,
>> > extract all meaningfull tables, and then pitr to the second timestamp
>> > so as to be able to script a kind of "diff" between the 2 to get what I
>> want.
>>
>> Sure, you can do that.
>>
>> The description of what you wanted to do was rather unclear, all I could
>> make out is that you want to query AS OF TIMESTAMP.
>>
>> Yours,
>> Laurenz Albe
>> --
>> Cybertec | https://www.cybertec-postgresql.com
>>
>>
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | stan | 2019-11-22 12:50:52 | A question about user atributes |
Previous Message | Ganesh Korde | 2019-11-22 10:01:52 | Re: Extract transactions from wals ?? |