pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedold cluster does not use data checksums but the new one does
8+ messages / 3 participants
[nested] [flat]
* old cluster does not use data checksums but the new one does
@ 2019-05-05 11:32 Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Mariel Cherkassky @ 2019-05-05 11:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hey,
I'm trying to upgrade from PG9.6 to PG11.2 but I'm getting the following
error :
old cluster does not use data checksums but the new one does
As you can understand from the message, my old cluster doesnt use data
checksums and I want t enable this feature in the newer version. Is there
any way to handle it ?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 12:04 Bruce Momjian <bruce@momjian.us>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2019-05-05 12:04 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Sun, May 5, 2019 at 02:32:46PM +0300, Mariel Cherkassky wrote:
> Hey,
> I'm trying to upgrade from PG9.6 to PG11.2 but I'm getting the following error
> :
>
> old cluster does not use data checksums but the new one does
>
>
> As you can understand from the message, my old cluster doesnt use data
> checksums and I want t enable this feature in the newer version. Is there any
> way to handle it ?
You have to initialize your new cluster with checksums disabled.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 15:58 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 8+ messages in thread
From: Mariel Cherkassky @ 2019-05-05 15:58 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin@lists.postgresql.org
So basically I dont have any other option ?
My only option is doing the upgrade with other tools and not with
pg_upgrade ?
בתאריך יום א׳, 5 במאי 2019 ב-15:04 מאת Bruce Momjian <bruce@momjian.us
>:
> On Sun, May 5, 2019 at 02:32:46PM +0300, Mariel Cherkassky wrote:
> > Hey,
> > I'm trying to upgrade from PG9.6 to PG11.2 but I'm getting the following
> error
> > :
> >
> > old cluster does not use data checksums but the new one does
> >
> >
> > As you can understand from the message, my old cluster doesnt use data
> > checksums and I want t enable this feature in the newer version. Is
> there any
> > way to handle it ?
>
> You have to initialize your new cluster with checksums disabled.
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I. As I am, so you will be. +
> + Ancient Roman grave inscription +
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 16:11 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Scott Ribe @ 2019-05-05 16:11 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-admin@lists.postgresql.org
> 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 20:42 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 8+ messages in thread
From: Mariel Cherkassky @ 2019-05-05 20:42 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 20:44 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Scott Ribe @ 2019-05-05 20:44 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-admin@lists.postgresql.org
> 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 20:47 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 8+ messages in thread
From: Mariel Cherkassky @ 2019-05-05 20:47 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-admin@lists.postgresql.org
I see. To be honest i'm not so familiar with the checksums feature but I
understood that it is recommended to enable it in order to identify disk
corruptions. How useful is it ? In my case I'm upgrading a cluster that was
installed with checksums enabled so I have to choose between enabling it
and increasing the downtime (I'm familiar with logical replication decided,
in this case the upgrade happens when the system is down..) or disabling it
and decreasing the downtime. The question is how bad is it if I'll disable
it ?
בתאריך יום א׳, 5 במאי 2019 ב-23:44 מאת Scott Ribe <
scott_ribe@elevated-dev.com>:
> > 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.
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: old cluster does not use data checksums but the new one does
@ 2019-05-05 20:56 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Scott Ribe @ 2019-05-05 20:56 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-admin@lists.postgresql.org
> 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 ?
>
> בתאריך יום א׳, 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.
In my opinion, depends on your confidence in your disks & file system etc. For instance, given enterprisey hardware (channel per disk, no half-backed SATA multipliers, decent disks) + ZFS with appropriate redundancy, I wouldn't see the need. On the other hand, a desktop PC with some multi-disk USB box, and hell yeah I want checksums. Systems in between, harder judgment call...
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2019-05-05 20:56 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-05-05 11:32 old cluster does not use data checksums but the new one does Mariel Cherkassky <mariel.cherkassky@gmail.com>
2019-05-05 12:04 ` Bruce Momjian <bruce@momjian.us>
2019-05-05 15:58 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2019-05-05 16:11 ` Scott Ribe <scott_ribe@elevated-dev.com>
2019-05-05 20:42 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2019-05-05 20:44 ` Scott Ribe <scott_ribe@elevated-dev.com>
2019-05-05 20:47 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2019-05-05 20:56 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox