From: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz>, Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-bugs <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-29 07:45:22 |
Message-ID: | PS2PR06MB25013EE22028F69630528B43F06E0@PS2PR06MB2501.apcprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thanks to all for you we have solved "old and new pg_controldata WAL segment sizes are invalid or do not match " issue during upgrade.
[cid:image001(dot)jpg(at)01D64E17(dot)571003D0]
Below command details
PWD : /usr/pgsql-12/bin
1. Stop the server 12
2. Remove all data from location /var/lib/pgsql/12/data
3. Go to /usr/pgsql-12/bin
4. Run below command
./initdb -D /var/lib/pgsql/12/data -U postgres --wal-segsize=64
5. run Upgrade command :
/usr/pgsql-12/bin/pg_upgrade --old-datadir /var/lib/pgsql/11/data/ --new-datadir /var/lib/pgsql/12/data/ --old-bindir /usr/pgsql-11/bin/ --new-bindir /usr/pgsql-12/bin/
Regards,
Ram Pratap.
Lava International Limited.
Tel+ 91-120-4637148
-----Original Message-----
From: Michael Paquier [mailto:michael(at)paquier(dot)xyz]
Sent: 29 June 2020 13:05
To: Bruce Momjian
Cc: Stephen Frost; Tom Lane; Jeff Janes; Ram Pratap Maurya; pgsql-bugs
Subject: Re: BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match
On Sat, Jun 27, 2020 at 05:26:10PM -0400, Bruce Momjian wrote:
> Instead of mentioning a specific wal_level "or higher", I decided to
> just mention the WAL level _not_ to use; patch attached.
Sounds fine to me, thanks!
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2020-06-29 09:13:52 | BUG #16516: when testing jit get terminate called after throwing an instance of 'std::bad_function_call' |
Previous Message | Michael Paquier | 2020-06-29 07:35:01 | Re: BUG #16497: old and new pg_controldata WAL segment sizes are invalid or do not match |