public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim Nasby <[email protected]>
To: Tory M Blue <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Clarification on using pg_upgrade
Date: Tue, 14 Jun 2016 16:03:19 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEaSS0Z-0eNY2Qhc8D5ywdRFxadHEhAZkEuYOeZCKxfOt142Mg@mail.gmail.com>
References: <CAEaSS0atiPVYLhMSwtzcZB5efeTxYjYDR1s3OZSshpkAY1VsAg@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAEaSS0bi0oAk2u615P-WmtLj3XfvAeBBLgO05nxyK5tD7Pui5Q@mail.gmail.com>
<[email protected]>
<CAEaSS0Z-0eNY2Qhc8D5ywdRFxadHEhAZkEuYOeZCKxfOt142Mg@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On 4/19/16 11:01 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 why the 7-13 hours causes an issue? Because if I'm upgrading
> via slon process, I have to add and drop a node. If I'm dropping my
> secondary (slave) I have to move reporting to the master, so now the
> master is handing normal inserts and reports. Next item, I'm without
> a replica for 13+ hours, that's not good either.
Don't drop and add a node, just do a master switchover. AFAIK that's
nearly instant as long as things are in sync.
--
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
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Clarification on using pg_upgrade
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox