Horton

Re: Very URGENT REQUEST - Postgresql error : PANIC: could not locate a valid checkpoint record

Julien Rouhaud <rjuju123@gmail.com>

View thread
From: Julien Rouhaud <rjuju123@gmail.com>
To: "Agarwal, Pragati - Dell Team" <Pragati.A@dellteam.com>
Cc: Merlin Moncure <mmoncure@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>, "Silaparasetti, Ramesh" <Ramesh.Silaparasetty@dell.com>, "Kishore, Nanda - Dell Team" <Nanda.Kishore@dellteam.com>, "Mahendrakar, Prabhakar - Dell Team" <Prabhakar.Mahendraka@dellteam.com>
Date: 2022-02-11T12:34:09Z
Lists: pgsql-bugs 
On Fri, Feb 11, 2022 at 11:19:54AM +0000, Agarwal, Pragati - Dell Team wrote:
> Hi Merlin, Julien
>
> Thanks for your response.
>
> Besides this, there is public schema in postgres which we are not using in
> our Datastore service.
>
> As a workaround of an upgrade process, we plan to drop the public schema. We
> would like to know your thoughts on this and any detrimental impact on the
> data or service.

I'm not sure how that's a workaround, but that schema isn't necessary for
postgres, it's just a schema that's created by default.  You can remove it
without impact as long as you don't rely on it in any of your applications.