pg_receivexlog, pg_basebackup and data durability

Edit
ID 589
Title pg_receivexlog, pg_basebackup and data durability
Topic Bug Fixes
Created 2016-03-26 22:07:35
Last modified 2016-09-29 15:34:23 (8 years, 1 month ago)
Latest email 2016-09-29 21:53:22 (8 years, 1 month ago)
Status
2016-09: Committed
Target version
Authors Michael Paquier (michael-kun)
Reviewers Peter Eisentraut (petere), Gerdan Santos (gerdan)Become reviewer
Committer Peter Eisentraut (petere)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/589
git checkout commitfest/cf/589
Emails
silent data loss with ext4 / all current versions
First at 2015-11-27 11:17:49 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest at 2016-05-12 11:09:06 by Michael Paquier <michael.paquier at gmail.com>
Latest attachment (0001-Issue-fsync-more-carefully-in-pg_receivexlog-and-pg_.patch) at 2016-05-12 05:58:30 from Michael Paquier <michael.paquier at gmail.com>
    Attachment (0001-Issue-fsync-more-carefully-in-pg_receivexlog-and-pg_.patch) at 2016-05-12 05:58:30 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (pg_receivexlog-sync-94-93.patch) at 2016-03-28 04:49:46 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Issue-fsync-more-carefully-in-pg_receivexlog-and-pg_.patch) at 2016-03-27 23:25:09 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0001-Close-file-descriptor-associated-to-backup_label-cor.patch) at 2016-03-18 06:08:32 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Close-file-descriptor-associated-to-backup_label-cor.patch) at 2016-03-17 14:05:42 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Make-rename-calls-for-log-files-in-adminpack-durable.patch) at 2016-03-15 14:39:50 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Introduce-durable_rename-and-durable_link_or_rename.patch) at 2016-03-08 05:55:52 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0001-durable-rename-andres-v8.patch) at 2016-03-07 06:38:40 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (xlog-fsync-v7.patch) at 2016-03-05 13:25:36 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (xlog-fsync-v6.patch) at 2016-02-24 07:06:10 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (xlog-fsync-v5.patch) at 2016-02-05 09:40:59 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (xlog-fsync-v4.patch) at 2016-02-04 09:02:32 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (xlog-fsync-v3.patch) at 2016-01-25 07:30:47 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (xlog-fsync-v2.patch) at 2015-12-01 22:05:52 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (power-failure-device.jpg) at 2015-11-27 14:02:38 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (xlog-fsync.patch) at 2015-11-27 11:17:49 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
pg_basebackup, pg_receivexlog and data durability (was: silent data loss with ext4 / all current versions)
First at 2016-05-13 06:39:35 by Michael Paquier <michael.paquier at gmail.com>
Latest at 2016-09-29 21:53:22 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (0001-Relocation-fsync-routines-of-initdb-into-src-common.patch) at 2016-09-23 15:15:22 from Michael Paquier <michael.paquier at gmail.com>
    Attachment (0001-Relocation-fsync-routines-of-initdb-into-src-common.patch) at 2016-09-23 15:15:22 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Relocation-fsync-routines-of-initdb-into-src-common.patch) at 2016-09-13 04:16:58 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Relocation-fsync-routines-of-initdb-into-src-common.patch) at 2016-09-03 13:23:26 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Relocation-fsync-routines-of-initdb-into-src-common.patch) at 2016-09-02 06:50:58 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (0001-Relocation-fsync-routines-of-initdb-into-fe_utils.patch) at 2016-05-13 06:39:35 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
History
When Who What
2016-09-29 15:34:23 Peter Eisentraut (petere) Closed in commitfest 2016-09 with status: Committed
2016-09-29 15:34:23 Peter Eisentraut (petere) Changed committer to petere
2016-09-25 22:11:35 Michael Paquier (michael-kun) New status: Needs review
2016-09-23 02:00:16 Peter Eisentraut (petere) New status: Waiting on Author
2016-09-13 07:53:05 Michael Paquier (michael-kun) New status: Needs review
2016-09-10 09:29:31 Peter Eisentraut (petere) New status: Waiting on Author
2016-08-31 15:05:52 Peter Eisentraut (petere) Added petere as reviewer
2016-08-18 17:12:09 Gerdan Santos (gerdan) Added gerdan as reviewer
2016-05-13 06:41:39 Michael Paquier (michael-kun) Changed name to pg_receivexlog, pg_basebackup and data durability
2016-05-13 06:41:17 Michael Paquier (michael-kun) Attached mail thread CAB7nPqQ_B0j3n1t=8c1ZLHXF1b8Tf4XsXoUC9bP9t5Hab--SMg@mail.gmail.com
2016-03-31 00:50:51 Michael Paquier (michael-kun) Changed name to pg_receivexlog missing fsync calls of data directory
2016-03-26 22:07:49 Michael Paquier (michael-kun) Changed authors to Michael Paquier (michael-kun)
2016-03-26 22:07:35 Michael Paquier (michael-kun) Attached mail thread 56583BDD.9060302@2ndquadrant.com
2016-03-26 22:07:35 Michael Paquier (michael-kun) Created patch record
Edit