Re: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match
Date
Msg-id 20200618080509.GH118592@paquier.xyz
Whole thread Raw
In response to BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
Re: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match  (Jeff Janes <jeff.janes@gmail.com>)
List 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

Attachment

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16499: Escape Characters in FTS
Next
From: PG Bug reporting form
Date:
Subject: BUG #16500: SQL Abend. select multi_key_columns_range_partition_table