Running rsync backups in pg15

Поиск
Список
Период
Сортировка
Искать
От
Murthy Nunna
Тема
Running rsync backups in pg15
Дата
Msg-id
DM8PR09MB667714AB7E04AB70B4B5A7B1B85C2@DM8PR09MB6677.namprd09.prod.outlook.com
Список
Дерево обсуждения
Running rsync backups in pg15 Murthy Nunna <mnunna@fnal.gov>
RE: Running rsync backups in pg15 <msalais@msym.fr>
Re: Running rsync backups in pg15 Laurenz Albe <laurenz.albe@cybertec.at>
Re: Running rsync backups in pg15 Ron Johnson <ronljohnsonjr@gmail.com>
Re: Running rsync backups in pg15 Evan Rempel <erempel@uvic.ca>
Re: Running rsync backups in pg15 Scott Ribe <scott_ribe@elevated-dev.com>
Re: Running rsync backups in pg15 Ron Johnson <ronljohnsonjr@gmail.com>
Re: Running rsync backups in pg15 Evan Rempel <erempel@uvic.ca>
Re: Running rsync backups in pg15 Gerald Drouillard <gerald@drouillard.ca>

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.

 

 

В списке pgsql-admin по дате отправления
От: Ron Johnson
Дата:
От: Ron Johnson
Дата:
FAQ