Re: pg_checksums?

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_checksums?
Date: 2023-10-29 09:11:07
Message-ID: 81D43A87-7D3D-4F81-B462-641F15B5E332@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Peter

> On Oct 29, 2023, at 02:43, Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:
> I don't think so. AFAIK Replication keeps the data files in sync on a
> bit-for-bit level and turning on checksums changes the data layout.
> Running a cluster where one node has checksums and the other doesn't
> would result in a complete mess.

I agree with the last sentence. This is why I asked if it is safe to enable checksums on a replica, switch over and then do it again on the ex primary, i.e. now new replica without doing a reinit.

Cheers
Paul

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2023-10-29 10:49:11 Re: pg_checksums?
Previous Message Peter J. Holzer 2023-10-29 01:43:10 Re: pg_checksums?