Re: BUG #18367: Cannot drop schema

On 2024-Feb-27, Tom Lane wrote:

> I would try to pg_dump the database, and if you can do that and
> reload successfully then discard the original.  If you've found
> one bit of catalog corruption there's likely more.

I second that recommendation.  However, there's also pg_catcheck which
could help diagnose and fix things, in case a dump/restore of the whole
database is impractical.  If you operate it wrong enough, you can
corrupt your whole database though.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
Voy a acabar con todos los humanos / con los humanos yo acabaré
voy a acabar con todos (bis) / con todos los humanos acabaré ¡acabaré! (Bender)