Re: Question about pg_upgrade from 9.2 to X.X

Hi Justin

I could see bunch of functions under reorg schema.

AS '$libdir/pg_reorg', 'reorg_disable_autovacuum';
AS '$libdir/pg_reorg', 'reorg_get_index_keys';
AS '$libdir/pg_reorg', 'reorg_apply';
AS '$libdir/pg_reorg', 'reorg_drop';
AS '$libdir/pg_reorg', 'reorg_indexdef';
AS '$libdir/pg_reorg', 'reorg_swap';
AS '$libdir/pg_reorg', 'reorg_trigger';
AS '$libdir/pg_reorg', 'reorg_version';

I am not sure about the impact of these functions if i drop .

Are these functions seeded ( default) one ?

Regards,
Raj

On Sun, Mar 3, 2019 at 7:38 PM Perumal Raj <perucinci(at)gmail(dot)com> wrote:

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