Re: Upgrade check failed from 11.5 to 12.1

On 12/19/20 8:13 AM, Lu, Dan wrote:

Please do not top post. Convention on this list is bottom/inline posting.
> Thanks Adrian.
>
> This is what I am seeing.
>
> postgresdbad:dpoc:pgdbadevbal800:> pg_controldata -D
> /hostname/pg/dev12upg/data | grep -i "Bytes per WAL segment"
>
> Bytes per WAL segment: 131072

Well that would be the problem.

Did someone manually change --wal-segsize during initdb or pg_ctl init?

In any case that is not going to work. I'm assuming the 12 instance is
not in use at this time. If so I would do the initdb again after
clearing the data directory. Don't use the --wal-segsize, it will
default to 16MB. Then check with pg_controldata to make sure the correct
size is set.

>
> postgresdbad:dpoc:pgdbadevbal800:> pg_controldata -D
> /hostname/pg/dpoc/data | grep -i "Bytes per WAL segment"
>
> Bytes per WAL segment: 16777216
>
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: Saturday, December 19, 2020 10:28 AM
> To: Lu, Dan <Dan(dot)Lu(at)sig(dot)com>; Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: Upgrade check failed from 11.5 to 12.1
>
> On 12/18/20 2:56 PM, Lu, Dan wrote:
>
> > Thanks for catching that.  Typo on my end.
>
> >
>
> > Now I am getting this.
>
> >
>
> > Performing Consistency Checks on Old Live Server
>
> > ------------------------------------------------
>
> > Checking cluster versions                                   ok
>
> >
>
> > old and new pg_controldata WAL segment sizes are invalid or do not
>
> > match Failure, exiting
>
> >
>
> > I found the setting in the current version of the instance via "show
> all" as "wal_segment_size                       | 16MB".   I guess my
> new instance should be "16MB" as well when running this "initdb
> --wal-segsize=16 -D /hostname/pg/NewInstance/data"?
>
> >
>
> Well the default is 16MB so you should not have to set it.
>
> What does:
>
> pg_controldata -D <11.5 data dir>
>
> pg_controldata -D <12.1 data dir>
>
> show for the setting Bytes per WAL segment: ?
>
> --
>
> Adrian Klaver
>
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
> ------------------------------------------------------------------------
>
> IMPORTANT: The information contained in this email and/or its
> attachments is confidential. If you are not the intended recipient,
> please notify the sender immediately by reply and immediately delete
> this message and all its attachments. Any review, use, reproduction,
> disclosure or dissemination of this message or any attachment by an
> unintended recipient is strictly prohibited. Neither this message nor
> any attachment is intended as or should be construed as an offer,
> solicitation or recommendation to buy or sell any security or other
> financial instrument. Neither the sender, his or her employer nor any of
> their respective affiliates makes any warranties as to the completeness
> or accuracy of any of the information contained herein or that this
> message or any of its attachments is free of viruses.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com