Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there something similar like flashback query from Oracle planned for PostgreSQL - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: Is there something similar like flashback query from Oracle planned for PostgreSQL
Date
Msg-id CAM+6J96Bvt_N6R5L3n7ybzuXQdErXcOxq+8z8Xh4D1nXLvMveQ@mail.gmail.com
Whole thread Raw
In response to Is there something similar like flashback query from Oracle planned for PostgreSQL  (Dirk Krautschick <Dirk.Krautschick@trivadis.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory
Next
From: Jerry LeVan
Date:
Subject: Re: Psql wants to use IP6 when connecting to self using tcp...