Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHg3x-0006Sh-Mv for pgsql-general@arkaria.postgresql.org; Mon, 05 Jun 2017 00:40:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dHg3v-00020e-IM for pgsql-general@arkaria.postgresql.org; Mon, 05 Jun 2017 00:40:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dHg1X-0006Bp-RT for pgsql-general@postgresql.org; Mon, 05 Jun 2017 00:37:35 +0000 Received: from itupa-meg1c.cw.unisa.edu.au ([130.220.96.210]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dHg1R-0006bP-Mg for pgsql-general@postgresql.org; Mon, 05 Jun 2017 00:37:33 +0000 Received: from ITUPW-EXMBOX2C.UniNet.unisa.edu.au (unknown [10.78.2.22]) by itupa-meg1c.cw.unisa.edu.au with smtp (TLS: TLSv1/SSLv3,128bits,AES128-SHA256) id 5feb_1863_d90680d2_f51e_44a1_abd8_ffc16e40f37d; Mon, 05 Jun 2017 10:07:17 +0930 Received: from ITUPW-EXMBOX2B.UniNet.unisa.edu.au (10.78.2.21) by ITUPW-EXMBOX2C.UniNet.unisa.edu.au (10.78.2.22) with Microsoft SMTP Server (TLS) id 15.0.1263.5; Mon, 5 Jun 2017 10:07:16 +0930 Received: from ITUPW-EXMBOX2B.UniNet.unisa.edu.au ([169.254.2.248]) by ITUPW-EXMBOX2B.UniNet.unisa.edu.au ([169.254.2.248]) with mapi id 15.00.1263.000; Mon, 5 Jun 2017 10:07:16 +0930 From: Dylan Luong To: "pgsql-general@postgresql.org" Subject: pg_rewind - enable wal_log_hints or data-checksums Thread-Topic: pg_rewind - enable wal_log_hints or data-checksums Thread-Index: AdLdknoO8rHCAl3uRJCweFk9EZP8jg== Date: Mon, 5 Jun 2017 00:37:15 +0000 Message-ID: Accept-Language: en-AU, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [130.220.0.2] Content-Type: multipart/alternative; boundary="_000_f9be7f2023784cbbb58255b0d9ea8281ITUPWEXMBOX2BUniNetunis_" MIME-Version: 1.0 X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 10 X-NAI-Spam-Score: 0.4 X-NAI-Spam-Rules: 5 Rules triggered DTP_2WD=0.1, GME_TWTRE=0.1, THREAD_INDX_INVALD_VAL=0.1, TRK_NCM1=0.1, RV6039=0 X-NAI-Spam-Version: 2.3.0.9418 : core <6039> : inlines <5905> : streams <1748534> : uri <2438295> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org --_000_f9be7f2023784cbbb58255b0d9ea8281ITUPWEXMBOX2BUniNetunis_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi In the PostgreSQL documentation for pg_rewind: pg_rewind requires that the target server either has the wal_log_hints opti= on enabled in postgresql.conf or data checksums enabled when the cluster wa= s initialized with initdb. What is the difference between the two options? What are the advantages and disadvantages between the two? Which one is the the preferred option? Thanks Regards Dylan --_000_f9be7f2023784cbbb58255b0d9ea8281ITUPWEXMBOX2BUniNetunis_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

In the PostgreSQL documentation for pg_rewind:<= /o:p>

 

pg_rewind requires that the target server either = has the wal_log_hints option enabled in postgresql.conf or data checksums e= nabled when the cluster was initialized with initdb.

 

 

What is the difference between the two options?=

What are the advantages and disadvantages between th= e two?

Which one is the the preferred option?

 

Thanks

Regards

Dylan

 

--_000_f9be7f2023784cbbb58255b0d9ea8281ITUPWEXMBOX2BUniNetunis_--