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 <peruci...@gmail.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 <pry...@telsasoft.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 >> >
