Re: help:how to rollback postgresql to several minutes ago - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: help:how to rollback postgresql to several minutes ago
Date
Msg-id CAB7nPqSE0qU3NLeoVB8OdmEpndgFdMYLysr5jQ=JDT1Js9S=0w@mail.gmail.com
Whole thread Raw
In response to help:how to rollback postgresql to several minutes ago  ("刘剑" <liujian@raintai.com>)
Responses Re: help:how to rollback postgresql to several minutes ago
List pgsql-bugs
On Thu, Apr 14, 2016 at 7:06 PM, =E5=88=98=E5=89=91 <liujian@raintai.com> w=
rote:
>  I had written an update sql without where condition to my table, then
> updated whole table.
> So how can i rollback this?

You need to roll in a backup I am afraid, and you should always have
some. Postgres has no way to replay back directly WAL records, it can
only forward replay. In such circumstances standby nodes with a delay
when applying WAL are useful.
--=20
Michael

pgsql-bugs by date:

Previous
From: Nick Cleaton
Date:
Subject: Re: Repeated requests for feedback in logical standby
Next
From: Michael Paquier
Date:
Subject: Re: help:how to rollback postgresql to several minutes ago