Soften pg_[start|stop]_backup to allow them on a standby?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Soften pg_[start|stop]_backup to allow them on a standby?
Date: 2014-01-14 03:31:09
Message-ID: CAB7nPqR-0asnHiBTnK3Se7mL-N7RW=hbBOHwCCPygVfHHYEnvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip kumar 2014-01-14 03:49:36 Case sensitive mode in windows build option
Previous Message Florian Pflug 2014-01-14 03:17:17 Re: Disallow arrays with non-standard lower bounds