| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Perumal Raj <perucinci(at)gmail(dot)com> |
| Cc: | Sergei Kornilov <sk(at)zsrv(dot)org>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Question about pg_upgrade from 9.2 to X.X |
| Date: | 2019-03-07 10:32:39 |
| Message-ID: | 20190307103239.GA8083@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2019-03-07 12:35:03 | Re: Update does not move row across foreign partitions in v11 |
| Previous Message | Nicola Contu | 2019-03-07 08:39:27 | Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2019-03-07 11:07:53 | Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath |
| Previous Message | Etsuro Fujita | 2019-03-07 10:27:33 | Re: Problems with plan estimates in postgres_fdw |