Re: Review my steps for rollback to restore point - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Review my steps for rollback to restore point
Date
Msg-id CAKAnmmKKYE8Re21ukcBdOfS5iVgOb5uyOJWAgGG8JbV7hZu-ww@mail.gmail.com
Whole thread Raw
In response to Re: Review my steps for rollback to restore point  (chandan Kumar <chandan.issyoga@gmail.com>)
List pgsql-general
On Thu, Mar 6, 2025 at 6:49 AM chandan Kumar <chandan.issyoga@gmail.com> wrote:
need any correction or advise.

Honestly, this all seems overly complex and fragile. I'm not sure what the overall goal is, but if it's to have a general PITR solution, use pgBackRest. If it's just to have a fall back method for a particular change, an easier solution is to stop replication, apply changes, and promote the replica if something goes wrong.

Either way, you should have a test system setup that you can try out your steps on. If a step fails and you do not understand why, this list is a great resource. Practice this a lot on test systems until it all becomes second nature.
 
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i
Next
From: mark bradley
Date:
Subject: Re: Duplicate Key Values