Re: Extract transactions from wals ?? - Mailing list pgsql-general

From Ganesh Korde
Subject Re: Extract transactions from wals ??
Date
Msg-id CAPNyb0VRhvkJZwOQi0cA9XUjyGgqN84Kd89Ld2meA4kJSQ4rFQ@mail.gmail.com
Whole thread Raw
In response to Re: Extract transactions from wals ??  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Extract transactions from wals ??  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
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.albe@cybertec.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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Extract transactions from wals ??
Next
From: Marc Millas
Date:
Subject: Re: Extract transactions from wals ??