Re: Extract transactions from wals ??

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Extract transactions from wals ??
Date: 2019-11-21 16:16:15
Message-ID: b401ea8ced7c777a536006f598fd7d5be9cea172.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2019-11-21 at 17:07 +0100, Marc Millas wrote:
> you say "extract the data you need"
> That is exactly the point of my question, as the PITR step was obvious.
> How to guess "what is the data" I need ??

Well, you asked for the contents of a table AS OF TIMESTAMP <something>.

That means you know which table and which timestamp.

So restore the PostgreSQL cluster to that timestamp, connect
and SELECT from the table.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-11-21 16:18:08 Re: Help with authentication on Debain/Ubuntu installation
Previous Message Marc Millas 2019-11-21 16:14:38 Re: Extract transaction from WAL