NEEDING HELP: dropping none-existing extension

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: NEEDING HELP: dropping none-existing extension
Date: 2020-04-04 15:48:24
Message-ID: 4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2020-04-04 16:09:34 Re: NEEDING HELP: dropping none-existing extension
Previous Message postgann2020 s 2020-04-04 03:02:03 Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables