At Thu, 18 Mar 2021 17:12:49 -0400, aslı cokay <aslicokay@xxxxxxxxx> wrote in > Hi all, > > Is there any way to get for example a table version of 5 minutes ago, or we > should PITR to 5 minutes ago, dump the table and restore with this dump ? If you want to revert the recent changes on the table, I think there's no way other than time-travelling using PITR. Of couse you can't do that only for a part of database. If you often want to access 5-minutes ago image of the database, you could configure a delayed standby using recovery_min_apply_delay. I'm not sure PostgreSQL has the same feature for logical replication, but perhaps we don't have that. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
