Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_upgrade question

pg_upgrade question

From
Mark Steben
Date:
Good afternoon,

I am hoping to use pg_upgrade with the link option to upgrade from 9.2 to 9.4.
We run redhat linux
This is the current configuration:

There is one set of binaries:
  /usr/local/postgresql-9.2.5 >>> upgrade to >>> /usr/local/postgresql-9.4.8.

However there are three sets of data clusters.  All on different disks - same file structure.  They are on the same physical machine but referenced by different i/ps and have to be referenced to different hosts:

first data cluster:
   /postgres_data/legacy/PSQL_92 >> upgrade to >> /postgres_data/legacy/PSQL_94
 to reference this at the command line within linux
   psql -U <<rolename?>>  << database>> -h  prod-legacy-psql.server.int

second data cluster
  /postgres_data/prime/PSQL_92  >> upgrade to>> /postgres_data/prime/PSQL_94
  to reference this at the command line within linux
   psql -U <<rolename?>>  << database>> -h  prod-prime-psql.server.int

third data cluster:
 /postgres_data/autoscheduler/PSQL_92  >> upgrade to>> /postgres_data/autoscheduler/PSQL_94
  to reference this at the command line within linux
   psql -U <<rolename?>>  << database>> -h  prod-autoscheduler-psql.server.int

Is this possible using pg_upgrade?  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.

Thanks for your time.
  


-- 
Mark Steben 
 Database Administrator
@utoRevenue | Autobase  
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089 
t: 413.327-3045 
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com






Re: pg_upgrade question

From
Tom Lane
Date:
Mark Steben <mark.steben@drivedominion.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.

            regards, tom lane

Re: pg_upgrade question

From
Bruce Momjian
Date:
On Thu, Aug 11, 2016 at 03:43:41PM -0400, Tom Lane wrote:
> Mark Steben <mark.steben@drivedominion.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.steben@drivedominion.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@momjian.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 +