RE: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match

Поиск
Список
Период
Сортировка
От Ram Pratap Maurya
Тема RE: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match
Дата
Msg-id PS2PR06MB250118FE05237919018A0E92F09B0@PS2PR06MB2501.apcprd06.prod.outlook.com
обсуждение исходный текст
Ответ на Re: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
Dear Michael,

Currently I hav installed postgres12 version , need to uninstall and reinstall again.
Or any command that we change current installation wal segment size.

Below location we have installed 12 version.

/var/lib/pgsql/12/data


Regards,
Ram Pratap.

-----Original Message-----
From: Michael Paquier [mailto:michael@paquier.xyz]
Sent: 18 June 2020 13:35
To: Ram Pratap Maurya; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match

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
definedat server initialization time using initdb with a default of 16MB, so that's not a bug from us, but something
youneed to take care of within your upgrade process. 
--
Michael



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: BUG #16500: SQL Abend. select multi_key_columns_range_partition_table
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match