RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-07-08 Thread Mahendrakar, Prabhakar - Dell Team
hanks, Prabhakar Internal Use - Confidential -Original Message- From: Michael Paquier Sent: Monday, June 27, 2022 5:34 AM To: Mahendrakar, Prabhakar - Dell Team Cc: Mateusz Henicz; pgsql-general@lists.postgresql.org Subject: Re: Postgresql error : PANIC: could not locate a valid check

Re: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-26 Thread Michael Paquier
On Fri, Jun 24, 2022 at 01:03:57PM +, Mahendrakar, Prabhakar - Dell Team wrote: > Is it possible to explicitly issue a checkpoint before we move on to > the pg_upgrade command? > so that in the circumstances of the Upgrade issues (like PANIC: > could not locate a valid checkpoint record), we

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-24 Thread Mahendrakar, Prabhakar - Dell Team
thoughts on this. Thanks, Prabhakar Internal Use - Confidential From: Mahendrakar, Prabhakar - Dell Team Sent: Wednesday, June 22, 2022 4:54 PM To: Mateusz Henicz Cc: pgsql-general@lists.postgresql.org Subject: RE: Postgresql error : PANIC: could not locate a valid checkpoint record Hello

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-22 Thread Mahendrakar, Prabhakar - Dell Team
Prabhakar - Dell Team; pgsql-general@lists.postgresql.org Subject: Re: Postgresql error : PANIC: could not locate a valid checkpoint record [EXTERNAL EMAIL] On Fri, 2022-06-17 at 06:35 +, Mahendrakar, Prabhakar - Dell Team wrote: > We are facing checkpoint related issues from PostGreSQL 1

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-22 Thread Mahendrakar, Prabhakar - Dell Team
: pgsql-general@lists.postgresql.org Subject: Re: Postgresql error : PANIC: could not locate a valid checkpoint record [EXTERNAL EMAIL] Could you also answer on questions asked by Laurenz Albe a few emails back? That could shed some light into your issue. We would know if the upgrade

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-21 Thread Mahendrakar, Prabhakar - Dell Team
-general@lists.postgresql.org Subject: RE: Postgresql error : PANIC: could not locate a valid checkpoint record Thanks for the response. Yes, we have taken care of proper shut down of Postgres before initiating the Upgrade. pg_resetwal - I have read that using pg_resetwal may cause the Database more

Re: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-21 Thread Mateusz Henicz
t; Thanks, > > Prabhakar > > > > > > Internal Use - Confidential > > *From:* Mahendrakar, Prabhakar - Dell Team > *Sent:* Monday, June 20, 2022 4:22 PM > *To:* Mateusz Henicz > *Cc:* pgsql-general@lists.postgresql.org > *Subject:* RE: Postgresql error :

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-20 Thread Mahendrakar, Prabhakar - Dell Team
: pgsql-general@lists.postgresql.org Subject: Re: Postgresql error : PANIC: could not locate a valid checkpoint record [EXTERNAL EMAIL] Assuming you have shut down your postgres properly before upgrading, it should be safe for you to run pg_resetwal. https://www.postgresql.org/docs/current/app

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-17 Thread Mahendrakar, Prabhakar - Dell Team
Yes, We are using the pg_upgrade utility of Postgres. From: Mateusz Henicz Sent: Friday, June 17, 2022 3:31 PM To: Mahendrakar, Prabhakar - Dell Team Cc: pgsql-general@lists.postgresql.org Subject: Re: Postgresql error : PANIC: could not locate a valid checkpoint record [EXTERNAL EMAIL] Hi

Re: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-17 Thread Laurenz Albe
On Fri, 2022-06-17 at 06:35 +, Mahendrakar, Prabhakar - Dell Team wrote: > We are facing checkpoint related issues from PostGreSQL 13.4 ( could not > locate a valid checkpoint record) and Postgres service fails to come up. >

Re: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-17 Thread Mateusz Henicz
ndr...@dellteam.com> napisał(a): > Yes, We are using the pg_upgrade utility of Postgres. > > > > *From:* Mateusz Henicz > *Sent:* Friday, June 17, 2022 3:31 PM > *To:* Mahendrakar, Prabhakar - Dell Team > *Cc:* pgsql-general@lists.postgresql.org > *Subject:* Re: Postgresql error

Re: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-17 Thread Mateusz Henicz
Hi, Have you done pg_upgrade post Postgres 13 installation? https://www.postgresql.org/docs/13/pgupgrade.html Cheers, Mateusz pt., 17 cze 2022 o 11:20 Mahendrakar, Prabhakar - Dell Team < prabhakar.mahendr...@dellteam.com> napisał(a): > Hello, > > > > Good Morning ! > > > > We are facing