Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qxgzQ-002o8C-FF for pgsql-general@arkaria.postgresql.org; Tue, 31 Oct 2023 05:08:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qxgzO-000W6v-3O for pgsql-general@arkaria.postgresql.org; Tue, 31 Oct 2023 05:08:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qxgzN-000W6n-MT for pgsql-general@lists.postgresql.org; Tue, 31 Oct 2023 05:08:29 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxgzK-003w5b-Uo for pgsql-general@lists.postgresql.org; Tue, 31 Oct 2023 05:08:28 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id 3f1490d57ef6-d9ac9573274so4750215276.0 for ; Mon, 30 Oct 2023 22:08:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698728905; x=1699333705; darn=lists.postgresql.org; h=mime-version:subject:references:in-reply-to:message-id:cc:to:from :date:from:to:cc:subject:date:message-id:reply-to; bh=8TmmVTzq3zI4BGIQ96CX3XeDACXvpamCezz66xC8rLk=; b=D/W1OettiXpRjHnFQy20jj5s1vbrrgpOMOAnEWOmCPNfV/Jiingb0cadqrXtEaaKoB 4ejXopiiQe/9y+x+WYVSYlJjq0XlUGR07f2+bOZZId+rbMDVya8FwQEthGbbZq55/kS/ oWbwFlziFAhwYvsRxKdb55U2xd4Eob+HYHoQihzNpcZKj3O63Ays/Qt9ybwmSeJ9FRDA fkJB0TuPbAh4XIqprIVTHg6f+c3JEbXnsxl8xHY59r4Ku3UWRGcb9xHePwVu48SoO/nd ZSiz14JEe94RqFELzsOhre6xh1ZtLC4a6u5vTp40fll2qAhJQ6xD5c8MzYW9v6AwBlJ8 mbDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698728905; x=1699333705; h=mime-version:subject:references:in-reply-to:message-id:cc:to:from :date:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=8TmmVTzq3zI4BGIQ96CX3XeDACXvpamCezz66xC8rLk=; b=ojCLSd9yM+jgmGH047GcLFYZSuxjYM2ddvO/KgWiattZEY2ChTmaqjw8x9ofsNEy3A dvjVieHVumUeZSwbP1H9ORUEIJJVNuaQOj1ncXRu9iy9MHadnBlpkHOlJEZAOonNbr1U m5S9KAwRSbaJ+/laVFiwnTdYXUUuz6G9/10KgGUUNxeawnV8LyVc8XI+rKzU60i2FrQ3 I1boB9pShLPuH5eh9xnZb0842SYFuGBjPUIJB4Xf2nwx8eesguJkTwhk5sdVoO5VcTbb LeCZI/OVJMuzwcjnLEeu+Swge32HBzz1VrP+82kCM7ZJ9hGunZN4KoiByr8PCSgMx3lh xJuA== X-Gm-Message-State: AOJu0Yyv90DhDN52f4CZDRnONKaxwZ6SkjLlt1iik92MQGl795LzAjKt /SUhGEIQ1qWj4tmP32k0+c933NwzYTGf+A== X-Google-Smtp-Source: AGHT+IFenIqPl/Kn/i8yhgi+pCI8i9m2trjGOtG270XPHbVTDtoWDbchVUEmlUwsw1LWXrGqVgfQTA== X-Received: by 2002:a25:83cd:0:b0:da0:48df:cb09 with SMTP id v13-20020a2583cd000000b00da048dfcb09mr10130658ybm.54.1698728904945; Mon, 30 Oct 2023 22:08:24 -0700 (PDT) Received: from email.client.edison.tech ([2400:1a00:b020:d439:6df5:7801:665c:6f1d]) by smtp.gmail.com with ESMTPSA id n15-20020a056a00212f00b00688965c5227sm354435pfj.120.2023.10.30.22.08.22 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 30 Oct 2023 22:08:23 -0700 (PDT) Date: Tue, 31 Oct 2023 10:53:21 +0545 From: b55white To: "pgsql-generallists.postgresql.org" Cc: "pgsql-generallists.postgresql.org" Message-ID: In-Reply-To: <7E295951-4481-457F-93E6-D8A55D7A15A2@gmail.com> References: <7E295951-4481-457F-93E6-D8A55D7A15A2@gmail.com> <20231029014310.7pbdfhincj2tds4l@hjp.at> <81D43A87-7D3D-4F81-B462-641F15B5E332@gmail.com> <22272207-E6E5-4DD5-9BD4-5F6B647E2C3B@gmail.com> <20231029104911.dj73ivozabdr5or4@hjp.at> <0D18D31E-EF52-434D-875C-08BEC8DDD553@yesql.se> Subject: Re: pg_checksums? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="EdoMail65408bc5_34d2d9b0_2635" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --EdoMail65408bc5_34d2d9b0_2635 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =20 =20 =20 > =20 > On Oct 30, 2023 at 7:00 PM, Paul =46=C3=B6rster wrote: > =20 > =20 > Hi Michael, > > > On Oct 30, 2023, at 01:56, Michael Paquier = wrote: > > =20 > > > - Enable checksums on the previous primary. > > - Start the previous primary to be a standby of the node you failed > > over to. > > That's exactly the reasoning behind my initial idea and question. Patro= ni does the switchover job for me including catching up on the latest cha= nges, etc. > > Seems that opinions vary. Are there any hard facts=3F > > =20 > The best hard facts are those generated in your environment. =20 > =20 > =20 > It turns out that enabling checksums can take quite some time to comple= te, i.e. downtime for the application which is hard to do in a 24x7 envir= onment. > > Yes. Try it first with a smaller sample. =20 > =20 > Cheers > Paul > > =20 --EdoMail65408bc5_34d2d9b0_2635 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
On Oct 3= 0, 2023 at 7:00 PM, Paul =46=C3=B6rster <paul.foerster=40gmail.com> wrote:

Hi Michael,

> On Oct 30, 2023, at 01:56, Michael Paquier= <michael=40paquier.xyz> wrote:
>
> > - Enable chec= ksums on the previous primary.
> - Start the previous primary to be= a standby of the node you failed
> over to.

That's exactly = the reasoning behind my initial idea and question. Patroni does the switc= hover job for me including catching up on the latest changes, etc.
Seems that opinions vary. Are there any hard facts=3F

=
The best hard facts are those generated in your environment. 
<=
br>It turns out that enabling checksums can take quite some time to compl=
ete, i.e. downtime for the application which is hard to do in a 24x7 envi=
ronment.

Yes. Try it first with a smaller sample.

C= heers
Paul

=20
--EdoMail65408bc5_34d2d9b0_2635--