Soften pg_[start|stop]_backup to allow them on a standby?
От | Michael Paquier |
---|---|
Тема | Soften pg_[start|stop]_backup to allow them on a standby? |
Дата | |
Msg-id | CAB7nPqR-0asnHiBTnK3Se7mL-N7RW=hbBOHwCCPygVfHHYEnvw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Soften pg_[start|stop]_backup to allow them on a
standby?
|
Список | pgsql-hackers |
Hi all, This is perhaps something that has already been discussed on hackers, I just could not find anything in the archives. Currently, pg_start_backup and pg_stop_backup cannot run on a standby because it is not possible to write a backup_label file to disk, because of the nature of a standby server preventing to write any data in its PGDATA. Is this thought right? This is what the comments at the top of do_pg_start_backup make me conclude. Could we consider soften the rules of pg_start_backup and pg_stop_backup (aka allow creation of a backup_label file) to be able to run them on a standby? Or not? This could accelerate taking backups from standbys when taking backups locally. Another idea would be to send the backup label file directly as the output of pg_start_backup such as client application can grab it and reuse it. Any thoughts about that as well? Note that pg_basebackup uses the command BASE_BACKUP to bypass that and send directly the label file through a stream without writing it to disk, satisfying this condition and making possible the creation of backups from a standby. Regards, -- Michael
В списке pgsql-hackers по дате отправления: