Обсуждение: pgsql: Fix the torn-page hazard for PITR base backups by forcing full

Поиск
Список
Период
Сортировка

pgsql: Fix the torn-page hazard for PITR base backups by forcing full

От
tgl@postgresql.org (Tom Lane)
Дата:
Log Message:
-----------
Fix the torn-page hazard for PITR base backups by forcing full page writes
to occur between pg_start_backup() and pg_stop_backup(), even if the GUC
setting full_page_writes is OFF.  Per discussion, doing this in combination
with the already-existing checkpoint during pg_start_backup() should ensure
safety against partial page updates being included in the backup.  We do
not have to force full page writes to occur during normal PITR operation,
as I had first feared.

Modified Files:
--------------
    pgsql/src/backend/access/transam:
        xlog.c (r1.235 -> r1.236)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.235&r2=1.236)