Re: Question about pg_upgrade from 9.2 to X.X

Thanks.Will decently try that option and keep you posted.

Thanks again for redirecting to right group.

Perumal Raju

On Sun, Mar 3, 2019, 6:51 AM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:

> 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
>