| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Murthy Nunna <mnunna(at)fnal(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Running rsync backups in pg15 |
| Date: | 2024-11-08 10:23:04 |
| Message-ID: | be58813938787fe100373f0de82021760d61ce15.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2024-11-08 14:08:36 | Re: Running rsync backups in pg15 |
| Previous Message | Murthy Nunna | 2024-11-07 20:58:43 | RE: Running rsync backups in pg15 |