Re: old cluster does not use data checksums but the new one does

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: old cluster does not use data checksums but the new one does
Date: 2019-05-05 20:44:30
Message-ID: BC403CF3-6ED1-48E5-AA2A-6EDFD6B4FF47@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 5, 2019, at 2:42 PM, Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> wrote:
>
> in aspect of upgrade, what will be faster, pg_upgrade or dump and restore each db in the cluster ?

pg_upgrade is faster, potentially *MUCH* faster, but it does not allow you to change anything about the on-disk data structure, and storage of checksums is such a change.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mariel Cherkassky 2019-05-05 20:47:49 Re: old cluster does not use data checksums but the new one does
Previous Message Mariel Cherkassky 2019-05-05 20:42:39 Re: old cluster does not use data checksums but the new one does