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

From Ron
Subject Re: NEEDING HELP: dropping none-existing extension
Date
Msg-id 7853427a-c037-2bc1-f0b5-b54e8f1cccc1@gmail.com
Whole thread Raw
In response to NEEDING HELP: dropping none-existing extension  (Axel Rau <Axel.Rau@chaos1.de>)
List pgsql-admin
On 4/4/20 10:48 AM, Axel Rau wrote:
> 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?

Are you trying to drop the extension pg_repack *before* doing the upgrade?

-- 
Angular momentum makes the world go 'round.



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: NEEDING HELP: dropping none-existing extension
Next
From: Axel Rau
Date:
Subject: Re: NEEDING HELP: dropping none-existing extension