Re: Extract transaction from WAL

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Jill Jade <jill779ks(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Extract transaction from WAL
Date: 2019-11-21 14:42:30
Message-ID: 9ec989fc2b64327843f138cee5602cb5c0b59db8.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stan 2019-11-21 14:42:32 Re: Isolation of multiple databse instances provided by a single postgres server
Previous Message Sébastien Bihorel 2019-11-21 14:42:20