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

From Perumal Raj
Subject Resolved: Question about pg_upgrade from 9.2 to X.X
Date
Msg-id CALvqh4pNqfW9_nx2c3w8c=wrPZk_uxwbW5sGocYe+HyC+0gUcA@mail.gmail.com
Whole thread Raw
In response to Re: Question about pg_upgrade from 9.2 to X.X  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
Thanks again.

Perumal Raju

On Thu, Mar 7, 2019, 2:32 AM Justin Pryzby <pryzby@telsasoft.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

pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Question about pg_upgrade from 9.2 to X.X
Next
From: Arjun Ranade
Date:
Subject: Connection pooling for differing databases?