public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: 'Murthy Nunna' <[email protected]>
To: [email protected]
Subject: RE: Running rsync backups in pg15
Date: Mon, 11 Nov 2024 20:38:49 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <DM8PR09MB667714AB7E04AB70B4B5A7B1B85C2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: <DM8PR09MB667714AB7E04AB70B4B5A7B1B85C2@DM8PR09MB6677.namprd09.prod.outlook.com>

Hi,

 

First of all, have you ever thought what happens if your database crashed
while you are updating your single backup?! It is really a dangerous
scenario there!

 

But any way, I suppose you are using psql to do your pg_start_backup(),
pg_stop_backup().

What about this one (I didn’t change function names):

 

Select pg_start_backup();

\! your_rsync_script…

Select pg_stop_bacup();

 

This could be more sophisticated if you want…

 

Regards

 

Michel SALAIS

De : Murthy Nunna <[email protected]> 
Envoyé : jeudi 7 novembre 2024 17:35
À : [email protected]
Objet : Running rsync backups in pg15

 

Hi,

 

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.

 

Currently (pg14):

 

                In bash script (run from cron)

1.	psql Select pg_start_backup
2.	rsync
3.	psql Select pg_stop_backup

 

In pg15 and later:

 

In bash script (run from cron)

 

psql

Select pg_start_backup

! run-rsync-script

Select pg_stop_backup

 

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?

 

Thank you in advance for your ideas.

 

 

view thread (24+ 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]
  Subject: RE: Running rsync backups in pg15
  In-Reply-To: <[email protected]>

* 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