On Thu, 2024-11-07 at 16:35 +0000, Murthy Nunna wrote:
> In PG14 and earlier, there is no requirement to keep database connection while rsync
> is in progress. However, there is a change in PG15+ that requires rsync to be while
> we have the same database session open that executes SELECT pg_backup_start('label').
> This change requires a rewrite of existing scripts we have.
>
> It can be done, but it makes it ugly to check errors and so forth that occur in the rsync script.
>
> Anybody found an elegant way of doing this?
You could try
https://github.com/cybertec-postgresql/safe-backup
Yours,
Laurenz Albe