NEEDING HELP: dropping none-existing extension - Mailing list pgsql-admin

From Axel Rau
Subject NEEDING HELP: dropping none-existing extension
Date
Msg-id 4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE
Whole thread Raw
Responses Re: NEEDING HELP: dropping none-existing extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: NEEDING HELP: dropping none-existing extension  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Hi all

during upgrade from 11 to 12, pg_upgrade errors out:
- - -
could not load library "$libdir/pg_repack": ERROR:  could not access file "$libdir/pg_repack": No such file or
directory
Database: development
Database: operations
Database: pki_op
- - -
I find no extension pg_repack, only views with that name in those DBs.
While trying to drop them, I get:
- - -
ERROR: cannot drop schema repack because extension pg_repack requires it HINT: You can drop extension pg_repack
instead.
- - -

How can I get rid of those views?

Axel
---
PGP-Key: CDE74120  ☀  computing @ chaos claudius


Attachment

pgsql-admin by date:

Previous
From: postgann2020 s
Date:
Subject: Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-allthe tables
Next
From: Tom Lane
Date:
Subject: Re: NEEDING HELP: dropping none-existing extension