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 >