public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: chandan Kumar <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Review my steps for rollback to restore point
Date: Fri, 7 Mar 2025 08:45:12 -0500
Message-ID: <CAKAnmmKKYE8Re21ukcBdOfS5iVgOb5uyOJWAgGG8JbV7hZu-ww@mail.gmail.com> (raw)
In-Reply-To: <CAHV6zV=qjFSp6tnkbPoJiM9rKj+hkGryaOxGZw23JpokkJo7Sw@mail.gmail.com>
References: <CAHV6zV=XN-keoXn-Qi=vMBvfG5JGxjhdFKTksczizXSXC31fXg@mail.gmail.com>
<[email protected]>
<CAHV6zV=TP=LYexUs8ZTmJxYeoX2HKJHmVPApgrc3WJfYb3niDA@mail.gmail.com>
<CAKFQuwbeakn6f8Qo1nOked-unPjYd-_tkG38E0xmjwYpL=VLcg@mail.gmail.com>
<CAHV6zV=G3od8Pa7XOH5dR6LUZQ2aoM__zyV-GMWrfyz=gufF9A@mail.gmail.com>
<CAKFQuwbzEDV2e4yfSpr8SkLyxEmAk=WPn3uo3C2q+1xR5VymVA@mail.gmail.com>
<CAHV6zVm73D1pMUqg50Nep3pSh+eP-aAsRyUwu8qXFzudKjZb+g@mail.gmail.com>
<CAHV6zV=qjFSp6tnkbPoJiM9rKj+hkGryaOxGZw23JpokkJo7Sw@mail.gmail.com>
On Thu, Mar 6, 2025 at 6:49 AM chandan Kumar <[email protected]>
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
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
view thread (6+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Review my steps for rollback to restore point
In-Reply-To: <CAKAnmmKKYE8Re21ukcBdOfS5iVgOb5uyOJWAgGG8JbV7hZu-ww@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox