Search Postgresql Archives

Re: Question about pg_upgrade from 9.2 to X.X

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Moving to -general list (-hackers is for development topics like proposed
patches and patch reviews and beta testing and crash reports).

On Thu, Feb 28, 2019 at 10:13:58AM -0800, Perumal Raj wrote:
> could not load library "$libdir/pg_reorg":
> ERROR:  could not access file "$libdir/pg_reorg": No such file or directory

As Sergei said, you can run pg_dump -s and look for references to reorg, and
drop them.

Or, you could try this:
CREATE EXTENSION pg_reorg FROM unpackaged;

Or maybe this:
CREATE EXTENSION pg_repack FROM unpackaged;

If that works, you can DROP EXTENSION pg_repack;

Otherwise, I think you can maybe do something like:
DROP SCHEMA pg_repack CASCADE; -- or,
DROP SCHEMA pg_reorg CASCADE;

Please send output of: \dn




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux