From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
---|---|
To: | "Lu, Dan" <Dan(dot)Lu(at)sig(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Question on upgrading postgresql from 10.7 to 11.5 |
Date: | 2019-12-25 15:36:24 |
Message-ID: | CAOBaU_Zv8MmuLCx1EDgk45rSzYLB1_12pyezYRX=jKS+bcbSqg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Dec 25, 2019 at 3:42 PM Lu, Dan <Dan(dot)Lu(at)sig(dot)com> wrote:
>
> Hello,
>
> I am trying to upgrade my PG instance from 10.7 to 11.5.
>
> I got an error in doing so. Any idea what I am missing?
>
> Example: pg_upgrade -d /hostname/pg/dpoc/data -D /hostname/pg/dpoc115/data -b /hostname/pg/PostgreSQL-10.7/bin -B /hostname/pg/PostgreSQL-11.5/bin -p 5432 -P 9432 -c -v
>
> Error message:
>
> old and new pg_controldata WAL segment sizes are invalid or do not match
The message is pretty much self explanatory. It looks like you used
"initdb --wal-segsize" for the 11.5 cluster using a value different
from the one that were used in your 10.7 cluster (probably 16MB). You
can check the value for each using "SHOW wal_segment_size". You have
to recreate a new pg11 data directory using the same value as the 10.7
one. While at it, you should update the pg11 binary to the latest
minor version, 11.6.
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2019-12-25 15:48:54 | Re: Syntax question about returning value from an insert |
Previous Message | stan | 2019-12-25 15:26:38 | Syntax question about returning value from an insert |