Re: Extract transactions from wals ??
Laurenz Albe <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
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