Renamed pg_catalog schema

From: Praneel Devisetty <devisettypraneel(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Renamed pg_catalog schema
Date: 2022-06-29 05:37:46
Message-ID: CAHnVB4CBay+YExPwnxb+y8qewbhVoH5MTB-ZPHfD_TF2mK3+tw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi ,

pg_catalog schema has been accidentally renamed in a PG database.Renaming
it back to pg_catalog is failing with error:

ERROR: unacceptable schema name "pg_catalog"
DETAIL: The prefix "pg_" is reserved for system schemas.

Is there any way to bypass this?

pg_dump/restore are failing as pg_catalog could not be found.Any other way
to recover data?

Best regards
Praneel

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2022-06-29 06:01:12 Re: Renamed pg_catalog schema
Previous Message Ron 2022-06-28 21:46:31 Re: Postgres open source upgrades