Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bCvUr-0004zm-FC for pgsql-performance@arkaria.postgresql.org; Tue, 14 Jun 2016 21:03:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bCvUr-0002Zp-0q for pgsql-performance@arkaria.postgresql.org; Tue, 14 Jun 2016 21:03:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bCvUq-0002YR-BH for pgsql-performance@postgresql.org; Tue, 14 Jun 2016 21:03:40 +0000 Received: from mail-bn1on0054.outbound.protection.outlook.com ([157.56.110.54] helo=na01-bn1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bCvUl-0006Ir-JJ for pgsql-performance@postgresql.org; Tue, 14 Jun 2016 21:03:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=YPEAka/VruGoVoG3Gt6oh59ycUICGc6KYcNFHJNCDwg=; b=Ny5IXo16vb2m7YrWOkfouL6nUwBG1oljabr3+CcIgfTi617TkyCVz466hx3p94ZGFES8DYKiqrX+BMRr1Vsh4SE8R9sevRkgpaheiNWhtkeL97laCTtDXZn38MOgYMOhlWEc6aLmlshFWsUNLM/HqjR/khnE68D238t8rRIxbHk= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from ACA863AD.ipt.aol.com (162.199.211.57) by BLUPR11MB0675.namprd11.prod.outlook.com (10.163.216.145) with Microsoft SMTP Server (TLS) id 15.1.517.8; Tue, 14 Jun 2016 21:03:32 +0000 Subject: Re: Clarification on using pg_upgrade To: Tory M Blue References: <20160304225811.GE865@telsasoft.com> <56E2F672.7080305@BlueTreble.com> <57014F54.3050204@BlueTreble.com> CC: "pgsql-performance@postgresql.org" From: Jim Nasby Message-ID: <4241f359-ec01-dc73-f742-20fdbc81755a@BlueTreble.com> Date: Tue, 14 Jun 2016 16:03:19 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [162.199.211.57] X-ClientProxiedBy: SN1PR16CA0057.namprd16.prod.outlook.com (10.163.13.25) To BLUPR11MB0675.namprd11.prod.outlook.com (10.163.216.145) X-MS-Office365-Filtering-Correlation-Id: e164c8ae-41ef-431c-90a4-08d3949757d3 X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0675;2:LfeGlJOo00IPS2euhSamhmlVEZ39inaiBl+vCaYjWUg2iMqVKYE3mdASzHvydMsy/C9Gfa+OI7Zi0xcGvr/D4TUvpHP1xlCxzStKo6ytMX78p8DCL4VPeAYHkVjdq38CHI1g5D5wJIEGZUuMKWRzUQPimwBAIVkJf67r1fGB1Ng/SpnsMsQsZBoVmjNvxWkH;3:Tl3/sLNNxP7/fagvst+i1qR+SFf9E8cLIroKhUS/EcFz+sGE2/rfX5/PiVD1TVd18uaJIlApNBjfoMIfn9CMqrveomdshIwIhBg3+wovc69sZf4x39A1vhppNKtma2mK X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BLUPR11MB0675; X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0675;25:bhARgX3RH6FTzyGZtfAX2OQM2fBrAeCNHFxpaDv1siYBwP1+1EzqFdbrGVlgGmMmBfiuIZl8N9BndmlqUhvM17n98Da6wsoxiZ1mOQlrYMhmCcjwnFcHcFTqzC2l4GXupNn2gEOhMShYUDsqYvxT8M4U/5POP0wApnmopi/3lHPOYlU8idX9C9hE2MownTXrwRjwivXPokO8O2cJcYo3zWZicAAs/NKTNMZaCKYudoRSxnoWKgMhIE+g3zBGpj1ZHibAGJd0IV/Iwu6IybMhqzVXTd/DBwEDdPDwwpiq6oZzieHqvFR67Lx6ESvVNj7sTER1NYKukSy24xFfbfCunYSdWyIPLVMiel408Md//s8iaPYmMUIcLerPxYn6o6q/81tl8E4mXRVmpSkuDnr/Qmt9HJ6gcNlUREnyaeZsvuo202vxIsin+ALVVsdF+eLBAKB4+i3ej6q0nBRNEUQwGi3bTSajJMqvAK2MgGjyxA0LNsMCZeI6sdgXiWK6VqNXYziw0hkewnFumGkX4EUtX5xr9B3xXvTPhze7l9U8CAGlq7ToBssNvvqnGwUDBXK7PFWf22kc52g4+zoNU8AJRFX+ZjzswZfP1sgVKnSZH5TRQd/gT5d0ia3/RmAQwyeoAlB5a1FLhVpE68wUw9UoLL5cw7I1pAk+a2lX7pzGnqZbzO3dTe2Oe9ck27+3USe5rz/eFZhn2kxJiK4DGNBCIz88pjfEWnU9NxghpXPW2NXAj5VQp2hvGNZKGlCznKSNAZeRnr/PY7eNnOPHKcn0qfuUrZldyzkYER9sPDWtv+oZ67uvaWCC+MUjCGuQQnaRusCa2TqOl2IsnTXxI9cvFg== X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(211171220733660); X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040130)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6041072)(6043046);SRVR:BLUPR11MB0675;BCL:0;PCL:0;RULEID:;SRVR:BLUPR11MB0675; X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0675;4:cs92WPWKbtRjq9arIW3EaSEHPhPMEIn9mKqvN63NMpxM6cqWdqNWqZpD2UpHbm/ydaJaM+vz2Hpr1CyfsGh/0E0DrvWaTDBkrpn+OKLgz5ZffHn0rJgV56e+ixZg/VsNNkC11DsB93DPjdoU4UufP8YqWT7kXSJGf+zgfc5ysmKx1FlgynzLaG+eNoLzu2VXn26GzJYdL0NbgIpZ2VnmICzzHUZb/otGGlJAzYk4a4j0WlUIvw+3fRfXlcm26oB2puLzGyYJx105vVspOrAAtNiwM2z7yQRuL8lcmQxCmRNj1oJwm7vhRk84GxCZPLlg7r+Sqr6+r2Evtb4y5CRYyDfftdwnsQHMtEZdap1HQZmjAyf+3l4umxYmkV9qcXbenj2rcCrTXnjLIgf1aE8s/9fTxjy5oz/reUz4ndAG/IPNlwoxAL5dYOmG4EstUpTR/IWQuwtI6bwX9wb1RZOj7HG442bbeYHmtrLp36tp1Xw= X-Forefront-PRVS: 09730BD177 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(199003)(24454002)(189002)(377454003)(19580395003)(105586002)(68736007)(106356001)(83506001)(50466002)(189998001)(36756003)(33646002)(16601075003)(230700001)(31696002)(77096005)(15975445007)(42186005)(6116002)(81156014)(81166006)(8676002)(3846002)(2950100001)(586003)(31686004)(97736004)(4001350100001)(65806001)(47776003)(66066001)(65956001)(5008740100001)(54356999)(86362001)(23676002)(76176999)(50986999)(93886004)(101416001)(5004730100002)(2906002)(110136002)(1411001)(64126003)(4326007)(92566002)(65826006)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:BLUPR11MB0675;H:ACA863AD.ipt.aol.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;CAT:NONE;LANG:en;CAT:NONE; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtCTFVQUjExTUIwNjc1OzIzOmNwYytDanJtQ2NKYU8zcVhQTnl1OGl3Vi90?= =?utf-8?B?aXc2SVpSb2RNRE9LWXpPTVlNSDVnRzRFLyt5cjI0cnJqRk9YdGtiRTUzL0x3?= =?utf-8?B?NlZwamEzUmt6SzBvOEVzeGZSZUNYVWZYeUVxc3Frbzc0ck1rVjhEcXRiK1pR?= =?utf-8?B?dG9uNTEwOE4zTy9XWi9HUHZRSWNraC9kMHVsbHIvT3RUVE9SYUJNK1ZQUGtJ?= =?utf-8?B?d2NRN1Nyck8reW1rWU1xUlNwVE9XV3hTYU83SVpGVWRUZ2RxWlQ5NndrR1pm?= =?utf-8?B?Rnk2eXFab3RxQlQ4RUlVVGpGWXgwQlNOcVk4dHMrWXBsamcralpGckVXWmlN?= =?utf-8?B?OWorYmZXTjF0c2JsYlMwNHozMlpSb3lJTklkTEhJOERzNGR4WllKb283Z012?= =?utf-8?B?S1ZkQlNsVVZCK3g5Mnowc1dBLzFoMWRTYjU3Z00xeSswYUlJRDVRc0xNQjdH?= =?utf-8?B?b0QreVR4Y1pMcGF6UEhOVU8xTXRDK1JFYjZLUzVGVmJmMGdzcldHM0x4RHVO?= =?utf-8?B?bE5GTDZxN29mdmszc1p1REw1VDBPYXoxU2gwOWFVQzBmcHNNaWt3TXdXNVpU?= =?utf-8?B?ZnhaMjZaRGtWUFVrcEtYOUNRbUxEbWxTcTBUcHNQWnZ0N0JsRnh4MElNNzVz?= =?utf-8?B?L3U0R3ZWVnhwMXlzZStkdUhPNEs2QU9CZW5BdUZrRHdSVUp4R0k5MmM3U0Zv?= =?utf-8?B?RGM0ZkZ4Q0tBK0xJVWVmWFJDdC8xcmJaT0l1MjEzSG90MmZPRTE3VmdDU3Jj?= =?utf-8?B?UkR0UFFxVGxYQzRzRitnSWczOWhOaDZodXVaZDhBcWJ5MWdIdTZKL2JvdU1y?= =?utf-8?B?WlFyU1hIcVNLU2RjazdLTkszamNiU050bnFDZkduKzdUbUlvTS9MazlIdmdo?= =?utf-8?B?RDI5MVpCRVJ5M1JTQkFLdDJTMmpOazYweVhNaDB2dHVOM095ME5aMCtzL2tX?= =?utf-8?B?RlpObnJzaWgwWVhPYnVlS1VjMEdvUnl2WjU0M0tJTzNqRzNUZzJQaGVBcysw?= =?utf-8?B?T002WGcwcUxEa29WSDBxQStJbk1uM2NBcm51NlhTNzdXbXV5UXFhZzRsQmc1?= =?utf-8?B?OG1pN1d4OHZMZnZwRCtGK1NOUEdRSDBJcWpVbmd6anl1dUVsUVNHTFBodkZj?= =?utf-8?B?L3JXVnhLSzBBV0ZBZkFBem91MjFwNzRYNlRscjZMV2ZYMStBZW9SVXlXRVUr?= =?utf-8?B?N1JOYjJqSDU1amRheHhrM0J6VzZ3clZLREN2TXdhNElqQmVibkk2dzF6UVhn?= =?utf-8?B?eDNOYzlaN2FXUTRRU0c2MCtSTC9QM0RUWitxcmlMQ1U4YVJvOCtIZW81eHp4?= =?utf-8?B?d2FXWjBqK1JRdWExVkZZb1lMMXRSY1Ywb1hBY0tveVZpVlZidzJGUk8zRFNu?= =?utf-8?B?bzI3TU5kOUhlS0pzelhWT0RQckJ3Q2FtZEZJVkZCcnFKempoRHpEVzRxVjlI?= =?utf-8?B?SzZYV0Z4akRoQmJhc05oZWEvTDl3SHFBbGJ0UFR0V3I2cGxOS1RuMG9mdGpt?= =?utf-8?B?U1I4V1B3SDBPTloxa1Q5NkYrbE5PSjJiRUNlQUdXRkpBSHhXRjBCYmpxcXN1?= =?utf-8?B?bFIreW9VVk5OUThwZVpDVlBDcTYrdXVMczdQaVhlc1pGSll2S1dVeXdFenAx?= =?utf-8?B?RDFNWGpncVN3WjZEenc1eDNwSFBBWlJGK2NrOXFzVjg3YWxoWmdKSzVPQXhX?= =?utf-8?B?TEZzYnc2am9lV2MzVWpkbmFXZFQwZW9VdTRkOHpzNW1zZlZST2FidkJMTEJK?= =?utf-8?B?dUNYazFHN1VuOHd6aXlyUEluRVcyTi81UEJ1dVZmQ2gwWVVSQXVVdUxQdDgv?= =?utf-8?Q?e8mh1xsCL5Eon?= X-Microsoft-Exchange-Diagnostics: 1;BLUPR11MB0675;6:OQWCNSBVDPgzNADrAYWCNCvqef+LX2d36Vqb/W007rL2zkrbX34521cE4EqVYC4OGR/U0buRnXpkfV5AvXTBrGE/AHh9hqNJx599qeHrENZKpluulgzAhVATf1vDu2K4JIrRbGN3NrO1o03HzMW6zcVCB/cPsjYaxjoNT2jWhACH7qcrzyWO57iDZZFnxrRwzgslJIpasvATFNu5weSZEUg1lcT51Qq3feGEjrvqRLzQPT+sPcprNshbJT6aNp65SI7qtoZkLUP3WHnpWinbfVDwn/uVvYWTFeOuF7Ejtac=;5:FHPD7pNe8rkhTliWKNPPesDPOsJ1xL0D1uTSoa9dlO2Z3vxrDRhwgPr/NqujB7cY5EscjQgLhLo+JAzuqPbemIHp1tFxgANZ4/v4eDDHXiBdjqRFi8Kp0PvB4/x+TsChFMimvXJkp4ggAVIWlTYkHw==;24:LDuidsWM5feH9Hmw1GUQXscQq5r9X334fcfN6hsz5tQTvxL6Zth3BrA8SCDgcrqYduRsqDH+UEJw0usuXkxNNfpnBftKfzTEKvyWYo9nGX8=;7:Vb+UvhXLmc0Abw/r2/gS/FDaLeykWZ5OC1GAl6Wz7gdHa8If+1EmNTbNLHZJC9lYM9p1XP+nxmizBFNpFUttOS5Fsq8et9Y8FrpgjDKog85im0BjXhIvWEY54y/JMSR7h3sZdmlGhJMPU/p/NBkf9YqImPF8gDetV5QhnGo70eAlSnRBHQIKQPHI2xXsUgIP0KN1NWMwEDZzjhQ4lBIJKQ== SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 14 Jun 2016 21:03:32.0934 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BLUPR11MB0675 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance