From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade question |
Date: | 2016-08-23 20:20:07 |
Message-ID: | 20160823202007.GB3900@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Aug 11, 2016 at 03:43:41PM -0400, Tom Lane wrote:
> Mark Steben <mark(dot)steben(at)drivedominion(dot)com> writes:
> > I am hoping to use pg_upgrade with the link option to upgrade from 9.2 to
> > 9.4.
> > There is one set of binaries:
> > However there are *three *sets of data clusters.
> > Is this possible using pg_upgrade?
>
> As far as pg_upgrade is concerned, you'd just run it three times, once per
> data cluster.
>
> If you're trying to use it through some distro-provided wrapper script,
> it's possible that that would be difficult, but the paths you mention
> sound pretty homebrew so I'm guessing that that's not a problem.
Sorry late to reply, but in your case Mark, you would run pg_upgrade
three times, once for each data directory, but use the same binaries
directory each time --- I think that is what you were asking below:
> Mark Steben <mark(dot)steben(at)drivedominion(dot)com> writes:
> From the documentation it looks like there is a one-to-one correlation
> between the binaries and the data cluster - I don't see a 'multiple'
> option.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Feike Steenbergen | 2016-08-24 12:08:12 | Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? |
Previous Message | ChandraKiran Lingareddy | 2016-08-19 14:38:41 | While setting up new DR for 9.2 server I am facing some errors |