pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNEEDING HELP: dropping none-existing extension
4+ messages / 3 participants
[nested] [flat]
* NEEDING HELP: dropping none-existing extension
@ 2020-04-04 15:48 Axel Rau <Axel.Rau@chaos1.de>
2020-04-04 16:09 ` Re: NEEDING HELP: dropping none-existing extension Tom Lane <tgl@sss.pgh.pa.us>
2020-04-04 16:24 ` Re: NEEDING HELP: dropping none-existing extension Ron <ronljohnsonjr@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Axel Rau @ 2020-04-04 15:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
Attachments:
signature.asc (application/pgp-signature, 900B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: NEEDING HELP: dropping none-existing extension
2020-04-04 15:48 NEEDING HELP: dropping none-existing extension Axel Rau <Axel.Rau@chaos1.de>
@ 2020-04-04 16:09 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-04-04 16:47 ` Re: NEEDING HELP: dropping none-existing extension Axel Rau <Axel.Rau@chaos1.de>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2020-04-04 16:09 UTC (permalink / raw)
To: Axel Rau <Axel.Rau@chaos1.de>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: NEEDING HELP: dropping none-existing extension
2020-04-04 15:48 NEEDING HELP: dropping none-existing extension Axel Rau <Axel.Rau@chaos1.de>
2020-04-04 16:09 ` Re: NEEDING HELP: dropping none-existing extension Tom Lane <tgl@sss.pgh.pa.us>
@ 2020-04-04 16:47 ` Axel Rau <Axel.Rau@chaos1.de>
0 siblings, 0 replies; 4+ messages in thread
From: Axel Rau @ 2020-04-04 16:47 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
> Am 04.04.2020 um 18:09 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>
> 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 ...
You are right:
operations=# select * from pg_extension;
extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-----------+----------+--------------+----------------+------------+-----------+--------------
plpgsql | 10 | 11 | f | 1.0 | |
adminpack | 10 | 11 | f | 1.0 | |
pg_repack | 16386 | 2200 | f | 1.4.5 | |
(3 rows)
I was misleaded by pgadmin4 in the 1st place.
psql
drop extension pg_repack cascade ;
did the job. (-:
Thanks a lot, Axel
---
PGP-Key: CDE74120 ☀ computing @ chaos claudius
Attachments:
signature.asc (application/pgp-signature, 900B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: NEEDING HELP: dropping none-existing extension
2020-04-04 15:48 NEEDING HELP: dropping none-existing extension Axel Rau <Axel.Rau@chaos1.de>
@ 2020-04-04 16:24 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Ron @ 2020-04-04 16:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-04-04 16:47 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-04-04 15:48 NEEDING HELP: dropping none-existing extension Axel Rau <Axel.Rau@chaos1.de>
2020-04-04 16:09 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-04-04 16:47 ` Axel Rau <Axel.Rau@chaos1.de>
2020-04-04 16:24 ` Ron <ronljohnsonjr@gmail.com>
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