Re: Clarification on using pg_upgrade - Mailing list pgsql-performance

From Jim Nasby
Subject Re: Clarification on using pg_upgrade
Date
Msg-id 57014F54.3050204@BlueTreble.com
Whole thread Raw
In response to Re: Clarification on using pg_upgrade  (Tory M Blue <tmblue@gmail.com>)
Responses Re: Clarification on using pg_upgrade
List pgsql-performance
On 3/24/16 12:43 PM, Tory M Blue wrote:
> Slon is also starting to not be viable as it takes some indexes over 7
> hours to complete. So this upgrade path seemed to really be nice.

If you're standing up a new replica from scratch on the latest version,
I'm not really sure why that matters?

> Not sure how I can incorporate with my slon cluster, I guess that will
> be the next thing I research.

Not sure I'm following, but you can pg_upgrade your replicas at the same
time as you do the master... or you can do them after the fact.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column
Next
From: Jim Nasby
Date:
Subject: Re: Big number of connections