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.