Re: Question about pg_upgrade from 9.2 to X.X

On Wed, Mar 06, 2019 at 09:44:16PM -0800, Perumal Raj wrote:
> Any pointers for pg_repack schema creation ?

With recent postgres, you should use just: "CREATE EXTENSION pg_repack", which
does all that for you.

> Will there be any impact in the future , Since i used --link option ?

You probably have an old DB directory laying around which is (at least
partially) hardlinks.  You should remove it .. but be careful to remove the
correct dir.  My scripts always rename the old dir before running pg_upgrade,
so it's less scary to rm -fr it later.

Justin