Resolved: Question about pg_upgrade from 9.2 to X.X

Thanks again.

Perumal Raju

On Thu, Mar 7, 2019, 2:32 AM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:

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