Re: Extract transaction from WAL

Laurenz Albe <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <[email protected]> 
On Thu, 2019-11-21 at 12:11 +0400, Jill Jade wrote:
> I am new to Postgres and I have a query.
> 
>  I have updated a table which I should not have.
> 
>  Is there a way to extract the transactions from the WAL and get back the previous data?
> 
> Is there a tool that can help to get back the transactions?

This information is not contained in the WAL.

You'll have to restore a backup.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.