Thanks Sergei/Justin for the continues update. So reorg Schema might be created as part of some scripts prior to 9.2 Version ? These are the functions in DB not the Extension. However these functions will not run as the associated libraries are not exists in System now (9.2) and I hope no impact to system.
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'; Will continue 9.6 upgrade after dropping reorg schema. One Question need your address, Prior to 9.2 to 9.6 upgrade , I have tried 9.2 10.7 upgrade and failed similar error(you can refer beginning o the post ). > could not load library "$libdir/hstore": ERROR: could not access file "$libdir/hstore": No such file or directory > could not load library "$libdir/adminpack": ERROR: could not access file "$libdir/adminpack": No such file or directory > could not load library "$libdir/uuid-ossp": ERROR: could not access file "$libdir/uuid-ossp": No such file or directory These Extension seems to be standard. What is the use of these function and do we have any alternative in Higher version or Enhanced object if i drop it in 9.2 and continue upgrade to 10.7 Version. Thanks and Regards, On Mon, Mar 4, 2019 at 11:42 PM Sergei Kornilov <s...@zsrv.org> wrote: > Hi > > seems this is unpackaged extension, usually installed prior 9.1 release. > Maybe reorg even does not support "create extension" syntax. That was long > ago and project homepage is unavailable now. pg_repack documentation > mention "support for PostgreSQL 9.2 and EXTENSION packaging" as > improvements. > > > Are these functions seeded ( default) one ? > > No its not default. > > regards, Sergei >
