Postgres Pro
Downloads
Home   >   mailing lists

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

From Mariel Cherkassky
Subject Re: old cluster does not use data checksums but the new one does
Date
Msg-id CA+t6e1mP0Qzkw6HpoqeU6WN4_SbG0w=9MrZf3VhG9eMXBst2aw@mail.gmail.com
Whole thread Raw
In response to Re: old cluster does not use data checksums but the new one does  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: old cluster does not use data checksums but the new one does  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: old cluster does not use data checksums but the new one does  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
in aspect of upgrade, what will be faster, pg_upgrade or dump and restore each db in the cluster ?

‫בתאריך יום א׳, 5 במאי 2019 ב-19:11 מאת ‪Scott Ribe‬‏ <‪scott_ribe@elevated-dev.com‬‏>:‬
> On May 5, 2019, at 9:58 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
>
> My only option is doing the upgrade with other tools and not with pg_upgrade ?

Dump & restore; you're changing the on-disk file format, so attempts to use current disk files cannot work.

pgsql-admin by date:

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