Postgres Pro
Downloads
Home   >   mailing lists

Renamed pg_catalog schema - Mailing list pgsql-admin

From Praneel Devisetty
Subject Renamed pg_catalog schema
Date
Msg-id CAHnVB4CBay+YExPwnxb+y8qewbhVoH5MTB-ZPHfD_TF2mK3+tw@mail.gmail.com
Whole thread Raw
Responses Re: Renamed pg_catalog schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Postgres open source upgrades
Next
From: Tom Lane
Date:
Subject: Re: Renamed pg_catalog schema