From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: NEEDING HELP: dropping none-existing extension
Date: Sat, 4 Apr 2020 11:24:02 -0500
Message-ID: <7853427a-c037-2bc1-f0b5-b54e8f1cccc1@gmail.com> (raw)
In-Reply-To: <4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE>
References: <4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: NEEDING HELP: dropping none-existing extension
In-Reply-To: <7853427a-c037-2bc1-f0b5-b54e8f1cccc1@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox