Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1lmjAb-0007mX-9O
	for pgsql-performance@arkaria.postgresql.org; Fri, 28 May 2021 20:33:25 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1lmjAa-00011X-7I
	for pgsql-performance@arkaria.postgresql.org; Fri, 28 May 2021 20:33:24 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <postgresql@mailpen.com>)
	id 1lmjAZ-00011O-VO
	for pgsql-performance@lists.postgresql.org; Fri, 28 May 2021 20:33:23 +0000
Received: from aws.mailpen.com ([52.43.43.172] helo=aws2.mailpen.com)
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <postgresql@mailpen.com>)
	id 1lmjAW-0000Cw-2Z
	for pgsql-performance@lists.postgresql.org; Fri, 28 May 2021 20:33:22 +0000
Received: from [172.20.70.208] (unknown [50.35.114.95])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(No client certificate requested)
	by aws2.mailpen.com (Postfix) with ESMTPSA id A344AC54065
	for <pgsql-performance@lists.postgresql.org>;
 Fri, 28 May 2021 13:33:18 -0700 (PDT)
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster
To: pgsql-performance@lists.postgresql.org
References: <88dec70b-eb63-0b72-0b5d-253851ef127b@mailpen.com>
 <9fa75894-d3be-e40b-cd89-f641bdf85df0@dunslane.net>
From: "Dean Gibson (DB Administrator)" <postgresql@mailpen.com>
Organization: UltiMeth Systems
Message-ID: <0da29d18-8864-3e31-e2aa-21277bce6bff@mailpen.com>
Date: Fri, 28 May 2021 13:33:18 -0700
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
 Thunderbird/78.10.2
MIME-Version: 1.0
In-Reply-To: <9fa75894-d3be-e40b-cd89-f641bdf85df0@dunslane.net>
Content-Type: multipart/alternative;
 boundary="------------4AAD073729269ADF13270CAF"
Content-Language: en-US
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/0da29d18-8864-3e31-e2aa-21277bce6bff%40mailpen.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------4AAD073729269ADF13270CAF
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

On 2021-05-28 12:08, Andrew Dunstan wrote:
> On 5/28/21 2:48 PM, Dean Gibson (DB Administrator) wrote:
>> [Reposted to the proper list]
>>
>> ...
>>
>>
>> Have you tried reproducing these results outside RDS, say on an EC2 instance running vanilla PostgreSQL?
>>
>> cheers, andrew
>>
>> --
>> Andrew Dunstan
>> EDB: https://www.enterprisedb.com

That is step #2 of my backup plan:

 1.   Create an EC2 instance running community v9.6.  Once that is done
    & running successfully, I'm golden for a long, long time.
 2. If I am curious (& not worn out), take a snapshot of #1 & update it
    to v13.


-- Dean


--------------4AAD073729269ADF13270CAF
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 2021-05-28 12:08, Andrew Dunstan
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:9fa75894-d3be-e40b-cd89-f641bdf85df0@dunslane.net">
      <pre class="moz-quote-pre" wrap="">
On 5/28/21 2:48 PM, Dean Gibson (DB Administrator) wrote:
</pre>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">[Reposted to the proper list]

...


Have you tried reproducing these results outside RDS, say on an EC2 instance running vanilla PostgreSQL?

cheers, andrew

--
Andrew Dunstan
EDB: <a class="moz-txt-link-freetext" href="https://www.enterprisedb.com">https://www.enterprisedb.com</a>
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap=""></pre>
    </blockquote>
    <br>
    That is step #2 of my backup plan:<br>
    <br>
    <ol>
      <li> Create an EC2 instance running community v9.6.  Once that is
        done &amp; running successfully, I'm golden for a long, long
        time.<br>
      </li>
      <li>If I am curious (&amp; not worn out), take a snapshot of #1
        &amp; update it to v13.</li>
    </ol>
    <br>
    -- Dean<br>
    <br>
  </body>
</html>

--------------4AAD073729269ADF13270CAF--