Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffmBM-0001Wh-R1 for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jul 2018 13:07:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ffmBL-0000Hn-7F for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jul 2018 13:07:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffmA6-0005KN-PM for pgsql-hackers@lists.postgresql.org; Wed, 18 Jul 2018 13:06:34 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffmA1-0007DL-Aw for pgsql-hackers@postgresql.org; Wed, 18 Jul 2018 13:06:33 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 06D0F21AFA; Wed, 18 Jul 2018 09:06:28 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 18 Jul 2018 09:06:28 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=pZLQMdmxqQWV6b389/W4g2IOg2VPFT8Y6y68rHeLc3I=; b=q53WhJeJ zKk0U3kBX7GSzvkzEzh3qB24XCyHjYmyvi8pPT+hOD91ssrprxKdhUozINJ1GUkF Q+C7USYPTgfdswEyuAQ+xE3pHNswqqa3ly3e8z+94xOoVH7GsO1mHifZgu6SpEkP egnOZCj48J9FnNfcUipdXGJWEnh+I6h/a1oucM66blDk0kkQsd/NznC3HyJY6zl+ WRkB/WSEZqi1qDlJZwFkMddiEZ2anlpP1g1LWLRCbgeksN1/rwe0jcxqpYwinATx TgkgjhKoQ2ShaYRszJ0wvcPp123Iy8vWcAdgfo+39gEbX/C1KT2x5bewjvLJg/iq z53MiGeSkNun3A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=pZLQMdmxqQWV6b389/W4g2IOg2VPF T8Y6y68rHeLc3I=; b=tqnf7r6YQadA4k+n5nz4XFeWhs1YmEHGk+ZUCms2gzwSQ 7XBPlrvq65hmFSEw3L4X9Z2AgVZqyzThHZbIEMmJj75chM+87FO5V+rbPu5hcqHl I+F6YRJcTXzo59AXteVtGvtRDw+ZcqnqvEi6JHcXmeOR/uUYu6vRBHqBf8BZH1ny oZ2ID+Mj8R8eVcLkbMDLbOVPYl3BYUtFvkmYJSpKLZX9H4UNq3vQCYUNXShFxsJc BV2S4cmN6ulLO9TXDjNDjsVJHwbDi0ly6VNBUYdkh2ILnd9xXLGipQlO4yl3myFo 6ChWuUNx1vdDC7udRpDt3ucs6QRRE3k00WAs20U8g== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 657231026C; Wed, 18 Jul 2018 09:06:25 -0400 (EDT) Date: Wed, 18 Jul 2018 22:06:22 +0900 From: Michael Paquier To: Robert Haas Cc: Andrew Dunstan , Heikki Linnakangas , "pgsql-hackers@postgresql.org" Subject: Re: [HACKERS] WAL logging problem in 9.4.3? Message-ID: <20180718130622.GI8565@paquier.xyz> References: <20180704045912.GG1672@paquier.xyz> <20180711033241.GQ1661@paquier.xyz> <08b11907-d0b2-c396-2978-ba5aac1972df@iki.fi> <026AD6A1-3396-47F4-B87E-77E3F139D166@iki.fi> <20180717000129.GA3388@paquier.xyz> <3c1cf991-8846-9a6f-c669-e21f8ea9a6a4@2ndQuadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="p1Od3smaOkJqivj4" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --p1Od3smaOkJqivj4 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 18, 2018 at 06:42:10AM -0400, Robert Haas wrote: > On Tue, Jul 17, 2018 at 8:28 AM, Andrew Dunstan > wrote: >> Well, we'd be getting rid of it because of a danger of data loss which we >> can't otherwise mitigate. Maybe it does need to be backpatched, even if = we >> haven't had complaints. >=20 > What's wrong with the approach proposed in > http://postgr.es/m/55AFC302.1060805@iki.fi ? For back-branches that's very invasive so that seems risky to me particularly seeing the low number of complaints on the matter. -- Michael --p1Od3smaOkJqivj4 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAltPO04ACgkQnvQgOdby QH0hVw/+JjlGDhkTEImTcak3X7Nx/YM/Tk2dpbEaDfwqln61kkbpFXmX3RiWHCdt kyuGEsFWUpcfPJkdKmprJWq/gkOlPA/bYxLIDwg2mjGDueqmgHPqn6OFqlZ8WeZ6 zZRf6wLSlVZ/e6rB4pa+OVXWPaErFyxsnm598EWpeFyHQQJrLcDI1phN5ohthAQF r4p6thcpSeUQ+bVl9A0ziEsdv5CMvcD2++5uILZ/cnSMRujVbzOMb9NsPb4B1WE0 75BDGLrPDp84eGCq2n7i+BJMl9GNEez2sqThIuLXzov0qUaeY79tnpHD2CdgBrJ2 w5coANpphKcVEJJbnE7hjY+WRvvGxEj25upexONrAc5A2fiO1O7oT7Azj5PcIEM3 ddi8rxCaqpZbBZaLiz23WhYutDGs8f34zZhoHlpsQtNsrhuz+vGFijTFIeVMYSc1 O8vq8m2BtSct1j4iVahi14aLvdcs2nnhX4pHydabQotHZknNKihPQa9fr7gsG3Kr zFw+VBwC8T1GviarD73KXdjJUCpS60axaVUCvNJRb0Hme+vH5XVzldXcITq9rR6+ nZDM7qB/2GBuwVyX5/fRJ3fWImcjLhV6v4AeU7GtOMkPwR0RrITugH3OTtNUD2ca rnOXPtIO3tAQZd8odFkCbMhKrwiaTtC0YCFF42I3tXUYUDnv4Pk= =7LMO -----END PGP SIGNATURE----- --p1Od3smaOkJqivj4--