Re: Question about pg_upgrade from 9.2 to X.X - Mailing list pgsql-general

From Justin Pryzby
Subject Re: Question about pg_upgrade from 9.2 to X.X
Date
Msg-id 20190307103239.GA8083@telsasoft.com
Whole thread Raw
In response to Re: Question about pg_upgrade from 9.2 to X.X  (Perumal Raj <perucinci@gmail.com>)
Responses Resolved: Question about pg_upgrade from 9.2 to X.X
List pgsql-general
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


pgsql-general by date:

Previous
From: Nicola Contu
Date:
Subject: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Next
From: Perumal Raj
Date:
Subject: Resolved: Question about pg_upgrade from 9.2 to X.X