From: Tom Lane <tgl@sss.pgh.pa.us>
To: Axel Rau <Axel.Rau@chaos1.de>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: NEEDING HELP: dropping none-existing extension
Date: Sat, 04 Apr 2020 12:09:34 -0400
Message-ID: <25615.1586016574@sss.pgh.pa.us> (raw)
In-Reply-To: <4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE>
References: <4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE>
Axel Rau <Axel.Rau@chaos1.de> writes:
> 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.
It is really, really, really difficult to believe that you got that
error if there's not any extension pg_repack in the database. Even
granting the possibility of catalog corruption, there would have
to be some row in pg_extension containing extname = 'pg_repack', or
the message text could not have been generated. So look again ...
regards, tom lane
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: tgl@sss.pgh.pa.us, Axel.Rau@chaos1.de, pgsql-admin@lists.postgresql.org
Subject: Re: NEEDING HELP: dropping none-existing extension
In-Reply-To: <25615.1586016574@sss.pgh.pa.us>
* 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