Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1amld2-0003IC-Gi for pgsql-performance@arkaria.postgresql.org; Sun, 03 Apr 2016 17:16:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1amld0-0003zK-SM for pgsql-performance@arkaria.postgresql.org; Sun, 03 Apr 2016 17:15:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1amlbJ-000207-HY for pgsql-performance@postgresql.org; Sun, 03 Apr 2016 17:14:13 +0000 Received: from mail-bl2on0088.outbound.protection.outlook.com ([65.55.169.88] helo=na01-bl2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1amlbG-0004w5-1a for pgsql-performance@postgresql.org; Sun, 03 Apr 2016 17:14:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=M9WzaeZ3I9ZCAPrSbnvPeX3BjXy1hkhnBQhXhTvrHtM=; b=auRSX1ALoFLPGzSdpwpOC7yrjOhjyaZprTVcQC4aQ48nwkmj4F5Zn3xSXzk7UAdY7y2KF2uKt8QJh2bZ+ZF2RxzvjIJrBXkRYobAuA4VNEpmJTqg9on+kiXEJy4pkebCHSUmon1HUN5K8gCttzIOS2vxq4f/BW4FIi5MFW42cP4= Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:980c:d454:1ef5:9886) by BY2PR11MB0679.namprd11.prod.outlook.com (10.163.111.21) with Microsoft SMTP Server (TLS) id 15.1.447.15; Sun, 3 Apr 2016 17:14:04 +0000 Subject: Re: Clarification on using pg_upgrade To: Tory M Blue , "pgsql-performance@postgresql.org" References: <20160304225811.GE865@telsasoft.com> <56E2F672.7080305@BlueTreble.com> From: Jim Nasby Message-ID: <57014F54.3050204@BlueTreble.com> Date: Sun, 3 Apr 2016 12:13:56 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.7.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:980c:d454:1ef5:9886] X-ClientProxiedBy: CY1PR1101CA0016.namprd11.prod.outlook.com (10.169.17.26) To BY2PR11MB0679.namprd11.prod.outlook.com (10.163.111.21) X-MS-Office365-Filtering-Correlation-Id: 4e28241c-e026-43f2-6043-08d35be35c43 X-Microsoft-Exchange-Diagnostics: 1;BY2PR11MB0679;2:mEDtIomHyKWxUBEJ/Kj+lkxESW6vm4JZmOMMYU+vdtiWskMo+zhHDrp0xdHQMzdWpffenhtxhmUhPZVILF5b5AjLAZ8/mJ++55lTM+TVlBSwgc8iw7Qsk2i9V8Fc38YlH93Y1FHAdH1hrQ9BeGvLN7XU0biB7EWx05Elh0FpCmziYhbl2/ZH2G5FyVuVog+m;3:Ay67/fGiNvedqFbKvFGqAsAzyKnxHcG/Culg9hdOzGtTHyDUfD/UYvN1aBZJCHWFNnz6zz1JVQL/VgvFV5DbL6+ijLlgCDXCviwkaZkX7FTMmm21EyabIaYhHWNBMIr9;25:e7YfOBE92hpa8Nzpw3A7nGS2qRW1WBlSgugozwYPcFZcxwfUFPBZQIYrFd1Uou9D1oRA3im4/g18GffYtgc8taVJ1bdRfaULZkYaiEZppOULwiX2ptSHH96xaXMPdMmnlBwxT0EITTTWKrih8FYI3mSSJCj1A9Vy8YfUDcvjyofNr2PnlKhCRE1N0zOBGv05Y7ZQ7aIEFNt/0iVCkENvcmd8me/l07MWdXaGiieKQKBNE1EBC5HAYVeS4E065Mr0SR42OiNg6HIFJiive0e7ztIqDXCIdJ3h2p83KZVriCWLeZ7p49Pc9JZGZTPvcz6OO8HuXKMYbA1txUZMYAvVRzezabLVZRR5oBPojS72+HA=;20:5MK+gzb8g5gyq0ymns2i1u9B4oj6V5KwCp0KmmNb8euvbVXgBJ0NYBXIkXaSIm0Faa9wQidv3wfZ7NsX7NCYCqv/wpeG0UwXFnn1XCHeEf04C3n9oqyqPWYHUP2ksH8uP2EkVZIpmYvT6hUxW3i+T3KEz+mOI5lljuiUe0pdtCc= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BY2PR11MB0679; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040046)(601004)(2401047)(5005006)(8121501046)(3002001)(10201501046)(6041046)(6043046);SRVR:BY2PR11MB0679;BCL:0;PCL:0;RULEID:;SRVR:BY2PR11MB0679; X-Microsoft-Exchange-Diagnostics: 1;BY2PR11MB0679;4:XrzUfJA7uT8BtHwP7P2YyE5mpe5fX8zQ+7cNNX8NlvsQmBuopjgIZgPR/PPsAZDb3eFGKAxG6DcdkIHK586vBfyM16ilir/vagHxxf9JBN0J5bgastzf/dU/BcQ3qLuEsTVQ01ex7vL9Jd4o/m1IUwycEmgLy4QPTvVfQWT/1Uy0bGiF3iRIUayHFplT+oTQSjA1GUCes6WbMM1sDBwbBEynbQJNAlo4U0rZlNzft+GbI/FEaPWsKiexDqNjG77fxza5gLIEBydn66w6HH8qobIYJQNblqeoEFolarTJpg2mdKL9maq9jY6/k3u6J0U+SLEbbuxszKD4Lak1EMwea1r+BKsse7e6b5rLQdDz/GlVOcMQT81icg36jrzwMI5wm6Yt06qEn3h0xkTQCP0fbir4ym5rUSGIN2gOvjxt+yc= X-Forefront-PRVS: 09011458FC X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(377454003)(24454002)(6116002)(42186005)(53416004)(2906002)(36756003)(81166005)(2501003)(2950100001)(50466002)(80316001)(83506001)(586003)(33656002)(19580395003)(65806001)(65956001)(4001350100001)(92566002)(47776003)(93886004)(230700001)(54356999)(5001770100001)(65816999)(189998001)(5008740100001)(23676002)(59896002)(50986999)(76176999)(87266999)(86362001)(15975445007)(77096005)(1096002)(5004730100002)(107886002)(3826002)(85282002)(336755003)(18886065003);DIR:OUT;SFP:1101;SCL:1;SRVR:BY2PR11MB0679;H:decina.attlocal.net;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtCWTJQUjExTUIwNjc5OzIzOnVXNWVmS3NTSmJrMDUyNEhjeURSTm1vNVA4?= =?utf-8?B?SHc0bzQ3M2hZNFpqSVpNWDFqTVhvV2g1SVdHbXUrVEY5UDJUeWw3YzZOVzJJ?= =?utf-8?B?NUo4QzllNGRMRWxIMHdTUG53N002UGNVdVdMQWR3eHdBVnVBSzljTjk3M1k5?= =?utf-8?B?TUs2OUF2clRYTnlZN0lKRmp3aTNQZk1QZWdzS204UmdhTmRWajlBZVh4azVP?= =?utf-8?B?c0xNYWRBUzNHeTV2ZERvdEZ2bGhCTnI0K3NkMGpiTlNTYVhyT0toT2JvM2hY?= =?utf-8?B?cFRpZWVZdTdUUXg3emo1WDVhTUpFOVQwbFM0VCtmbHRnaFZPNHQ4Vy9YSmxK?= =?utf-8?B?dUU5R202c3V5MlZ5ZjZCZm5rdkh3eE80SG9LbHdLVGFXcXF2WDNTdTYzNmRs?= =?utf-8?B?aGtwbExubG9VYStucU02TU5nODRHY2ZtUEErWGM2SWhxdHJSVm9QeXgzZ2RL?= =?utf-8?B?VDFwczQyNEFkVmRXN2NmM3REazI1SGVydjhOZWt5MVlIQnZ2dTd4OWovVk84?= =?utf-8?B?RnVFUmRpNEtoelpmMDYxVWhnY2lGMG5wMm9RU0M5aGU0ZzB5OFpkNXdxRE0x?= =?utf-8?B?LzRrWEo3dzdGZnlIMi9hd2RmaE4wQ1FrUWpXRlJ4RXFUZUhGVWZRL3hKRUIy?= =?utf-8?B?WTNmMy9qSHZBb1k4VDU0YVpFVlJMVU5vbzRheDBvaFRIYlYrRkJtMEVvN0Ny?= =?utf-8?B?Q3YxdHN3TnA1c3cyYlZwWlBFNHIxZzNML2JaTUxPRDFJQ2tBTkVKbW9MclNq?= =?utf-8?B?cElrTnNtc2VweksraGpvNEFqc0RPMWExM1FQaGJnOTFTUG1NZkY1anZURFZz?= =?utf-8?B?UCtGbGdwTTJaM1dyUk8zN2FWWmxPMEdrOHVhRGV0YjhSYVI2b1d1Q0VWemt2?= =?utf-8?B?QVhSb3FyRHZMTkZkTFJKMTQ4ZWZ5NjZmMWNBdEkzV0dhbitEMko3SzFkd3ll?= =?utf-8?B?d3ZBc0NkSTlUVzRvZllYZFVNK0VLZzdXMVVtQzBmd3JRTUdVbGFxNzhPa1Z2?= =?utf-8?B?M2d4VVRESzBDTE9EUlBnSno1MG84UkczYTE4WTExTjc3MjZCZjBiSjFpU3Jw?= =?utf-8?B?VnN2UjExQ1FMRklEK3JLV1hOdkFFV0lBZkFsM3RhV0x6ci9BKytrTUgxOVRZ?= =?utf-8?B?NURSZzc4MzZNMVBrdzFyajByR2hyZ2NjR1ptczlJdmplR2g3aWdNQS9paDli?= =?utf-8?B?UXp1b2JIenNjbWdlTW5TVjlhbmF0M2g4d3dsQ2dxNDFZQjg4VmRaeGNaK0xr?= =?utf-8?B?MEIrUGtuSGZBd002am10NmpRR0F4VGY2eEVWdEprS291QzVrRG1YUm1ZbzY1?= =?utf-8?B?RmVGanlGWFhvR1lUeGNKamsxZVkvM2srNWo1b3Y5Z3JwaHBuQ3gwaVUvb2JJ?= =?utf-8?B?cjJtTTZrZ2ZLejV2enNqMm1qTVMxL1hpeG10SlFwWUdRcEZWNzczNkZOK04x?= =?utf-8?B?ZjdiWjRWTmVYbkJlZWxNdG9ia0NNZ2h1YXNRS29jT0J6QkoyYUhHdkc4UlUy?= =?utf-8?B?WHBKZ0dWMXlNY2FRNEdBQ25weUJtdDgySUZnaUl4OXVxazhTOW5Pek1XWUJ6?= =?utf-8?Q?6/WFawKOwosbcWo+JpCIsnKsH9ycKj0SYJOwIaJvtCNM=3D?= X-Microsoft-Exchange-Diagnostics: 1;BY2PR11MB0679;5:XxZIF/q1vn3L2oZSfB53zsHZassudf5W4UZR+NVa3HKXiqhLK3vdYnhlGpiU+3OmtkcwIqT1eYegpIp/gnBKk1OxehOb9sswj5bQNXn6FpG0cN97baZH+pXYey2DHk3Ojrc9U9jiskS6p8H+nvd9Tg==;24:9UZdXmdGUWdBSleuk68DuQmxtIk/mX1QEAvI9zbsBdMjQp5owSgdjuX147yOuAcqsVOQrHbLnVnG1lAp/xHIxgtZ2lSt4GnjEgEQjyo36fg= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 03 Apr 2016 17:14:04.6276 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2PR11MB0679 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 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance