Re: BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: ram(dot)maurya(at)lavainternational(dot)in, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match
Date: 2020-06-18 08:05:09
Message-ID: 20200618080509.GH118592@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jun 17, 2020 at 09:00:23PM +0000, PG Bug reporting form wrote:
> I am facing error during upgrade from postgresql -11 to 12.
> can you please suggest what is solution.

As the error message is telling, you need to make the WAL segment
sizes of the old and new clusters match. This can be defined at
server initialization time using initdb with a default of 16MB, so
that's not a bug from us, but something you need to take care of
within your upgrade process.
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-06-18 09:35:27 BUG #16500: SQL Abend. select multi_key_columns_range_partition_table
Previous Message PG Bug reporting form 2020-06-18 06:31:08 BUG #16499: Escape Characters in FTS