Postgres Pro
Downloads
Home   >   mailing lists

Re: old cluster does not use data checksums but the new one does - Mailing list pgsql-admin

From Scott Ribe
Subject Re: old cluster does not use data checksums but the new one does
Date
Msg-id BC403CF3-6ED1-48E5-AA2A-6EDFD6B4FF47@elevated-dev.com
Whole thread Raw
In response to Re: old cluster does not use data checksums but the new one does  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: old cluster does not use data checksums but the new one does  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Tree view 
> On May 5, 2019, at 2:42 PM, Mariel Cherkassky <mariel.cherkassky@gmail.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.

pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: old cluster does not use data checksums but the new one does
Next
From: Mariel Cherkassky
Date:
Subject: Re: old cluster does not use data checksums but the new one does