Postgresql equivalent of flashback

postgresql flashback
Rauf Aliyev picture Rauf Aliyev · Aug 14, 2017 · Viewed 7.6k times · Source

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

Answer

Vao Tsun picture Vao Tsun · Aug 14, 2017

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

Related questions

PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More
PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More