On Wed, Dec 25, 2019 at 3:42 PM Lu, Dan <dan...@sig.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.
