Postgresql equivalent of flashback [duplicate]

Question

I'm Oracle Dba and want to learn Postgresql. Does it have equivalent of flashback in Postgresql?

your best shot is Continuous Archiving and Point-in-Time Recovery (PITR) — Ulug Toprak
– Ulug Toprak, Commented Aug 14, 2017 at 11:45

Vao Tsun · Accepted Answer · 2017-08-14 13:13:42Z

4

In short, no. Here's a good answer: https://dba.stackexchange.com/a/362/30035

And ATM the best practice as Laurenz suggests here: https://www.postgresql.org/message-id/A737B7A37273E048B164557ADEF4A58B36614938%40ntex2010i.host.magwien.gv.at

the lagging slave can show you the value some time ago (look recovery_min_apply_delay, or pg_xlog_replay_pause() fro pre 9.4 releases) - of course it's not a FRA, but can give you some place to move

answered Aug 14, 2017 at 13:13

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql equivalent of flashback [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related