Re: Is there something similar like flashback query from Oracle planned for PostgreSQL

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: Is there something similar like flashback query from Oracle planned for PostgreSQL
Дата
Msg-id CAM+6J96Bvt_N6R5L3n7ybzuXQdErXcOxq+8z8Xh4D1nXLvMveQ@mail.gmail.com
обсуждение исходный текст
Ответ на Is there something similar like flashback query from Oracle planned for PostgreSQL  (Dirk Krautschick <Dirk.Krautschick@trivadis.com>)
Список pgsql-general
Дерево обсуждения

On Thu, 24 Jun 2021 at 00:24, Dirk Krautschick <Dirk.Krautschick@trivadis.com> wrote:
Hi,
Is there something planned to get a behaviour like Oracle's flashback query based on the old values
before deleted by vacuum?

So a feature to recreate old versions of rows if still there?

Or are there any related extensions or tools doing this?


postgresql has external  tools like barman that ship WALs to a different location for point in time recovery.
That way, you can restore the db to any point in the past since the time you were collecting WALs.

if this is not the same, then please ignore the above :)


--
Thanks,
Vijay
Mumbai, India

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

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory
Следующее
От: Jerry LeVan
Дата:
Сообщение: Re: Psql wants to use IP6 when connecting to self using tcp...