Re: Extract transaction from WAL

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Extract transaction from WAL
Дата
Msg-id 9ec989fc2b64327843f138cee5602cb5c0b59db8.camel@cybertec.at
обсуждение исходный текст
Ответ на Extract transaction from WAL  (Jill Jade <jill779ks@gmail.com>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Sébastien Bihorel
Дата:
Сообщение:
Следующее
От: stan
Дата:
Сообщение: Re: Isolation of multiple databse instances provided by a singlepostgres server