Postgres Pro
Downloads
Home   >   mailing lists

Re: Extract transaction from WAL - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Extract transaction from WAL
Date
Msg-id 9ec989fc2b64327843f138cee5602cb5c0b59db8.camel@cybertec.at
Whole thread Raw
In response to Extract transaction from WAL  (Jill Jade <jill779ks@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Sébastien Bihorel
Date:
Subject:
Next
From: stan
Date:
Subject: Re: Isolation of multiple databse instances provided by a singlepostgres server