Postgres inplace PITR (point in time recovery) or rollback I have a Postgres 12.x database (that is cloud hosted).  This particular database instance is a nightly copy of production.  That is used for debugging etc ...
But during the debugging process we might want to roll it back to the time that it was created.
Is there an elegant way to do this?
I imagine like some uber transaction, that I can rollback to.  Is this crazy-talk -- or will postgres continue to amaze me.
There is no such facility in PostgreSQL but maybe a template database could help.
Create the template database as a copy of the production system. Then, whenever you need a test database, clone it with
CREATE DATABASE testdb TEMPLATE templatedb;