Re: Extract transactions from wals ??

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
>>
>>
>>
>>