Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there - Mailing list pgsql-bugs

From Andres Freund
Subject Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there
Date
Msg-id 20171108075827.uwfuqcii2bzrsnbl@alap3.anarazel.de
Whole thread Raw
In response to Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
On 2017-11-08 16:53:49 +0900, Michael Paquier wrote:
> You can check that by using a manual CHECKPOINT query for example.
> Based on what I see on this thread, my guess is that a failure would
> show up.

Not in the the default config, no?  Note the default config escape
hatch:
void
CheckPointTwoPhase(XLogRecPtr redo_horizon)
{int            i;int            serialized_xacts = 0;
if (max_prepared_xacts <= 0)    return;                    /* nothing to do */

- Andres


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there
Next
From: Stefan Tzeggai
Date:
Subject: Re: [BUGS] PG10 Segfault 11 on default Ubuntu 16.04 installs