Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1jCN-00EPe8-3A for pgsql-admin@arkaria.postgresql.org; Tue, 30 Apr 2024 08:50:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s1jCK-005Ef7-K7 for pgsql-admin@arkaria.postgresql.org; Tue, 30 Apr 2024 08:50:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1jCK-005Eex-3n for pgsql-admin@lists.postgresql.org; Tue, 30 Apr 2024 08:50:49 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s1jCI-000ou3-KO for pgsql-admin@postgresql.org; Tue, 30 Apr 2024 08:50:48 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-56e477db7fbso9195352a12.3 for ; Tue, 30 Apr 2024 01:50:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1714467045; x=1715071845; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=krznb1b7dqLj+zeP3+y4ZrJSvNXvmiJrarjUXOAbadg=; b=ZuYNokE9NZdHb/1gM6Rav8isr8m0bdrn3zuDqn2qyAJcdqRUnqorQ4+xAb8qHhDvpZ Ybwdlk/uvUGl0Yx39XqmsHEn5+IzGUcaGUIXnAd+2iGziI5eLbpHmtMOaD8qeY6ytBhe Gs9LT9CgJqag+SZrQLwZ6wJuXq5GI5wg9tOCm4m/40AORkuwBwWmVqbX10oCZappqYSN NnbCHUnbedTA8LUcLsIo8nBj1d65XpGAA+9xfr5W0SG2DPxgGo+vM47QGnnGTcGNtyRQ eFoisxKvmfCHy4obudbVMkNcBx9w4as5X8q6BCYFNt8UqEC/cUSlEg90ITs6tmNg1H/S zFYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714467045; x=1715071845; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=krznb1b7dqLj+zeP3+y4ZrJSvNXvmiJrarjUXOAbadg=; b=R1y5qSgsMBTFF16VV9dmaYybT0gabV3OUKRpGOl71WjVwiIRhfRh9FWqAAbZ1/g67o 6I6KPFYU/xpgGky6nXXxBnfsaZEWsv5OhJgaQ7M9vmUgjk8f1Zn2Yzfhh6VcF0t1j4Mf FfnNDl/Bk0X2CPO6DJG1s40u+dDIuFYtDLnUomzVh5qCAzDBSVyN+R6LaWu3W0MQr/1g DeaG+CngNu13wgUS4caSx9CZFuTDmkgKR8GFYKBBmOp4yR7tV6WrV5P8NLnkjAwL+rQX CfS5Lx7c5pYIm2O/fF2xxuD1V/FtneVRpYnDjpMK7xBgXb9XecgNXpgKqKJPoZBFVRoa Hviw== X-Forwarded-Encrypted: i=1; AJvYcCWOf8uTrjwDoMh3Empsx+OOwnV+CUy369+5VMtfTEHo/96ZhPquzP1cbaalwza33ob9pxQUVNfWjmet5fQMa6yTPJxZSOw+i7Z+LA== X-Gm-Message-State: AOJu0YzpOMMCN3OAAHgVj6lDL1eW8v/CtCwfkneell26qtYx8V7FKmgV f6eqKCYDfbs3JsbAqvT7qo/gaFRAOLV5+4EVKy7WDS960KonpHv0psUtc6+CYY5cFvzEt27azz+ h3vf7+w== X-Google-Smtp-Source: AGHT+IEeemNcBJ1O/5rtX4gaw22eiymREAESGi888EjxSpYg+UguwsZt//kO31p1ByjNuDbNvFwC9g== X-Received: by 2002:a17:906:f743:b0:a58:f13d:d378 with SMTP id jp3-20020a170906f74300b00a58f13dd378mr5582272ejb.13.1714467044966; Tue, 30 Apr 2024 01:50:44 -0700 (PDT) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id p11-20020a170906a00b00b00a55892e840bsm13234920ejy.205.2024.04.30.01.50.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 30 Apr 2024 01:50:44 -0700 (PDT) Message-ID: <8452a0ce5f84b48b326616029ae249fce67b36f2.camel@cybertec.at> Subject: Re: AWS RDS postgresql upgrade from 14 to 15 From: Laurenz Albe To: "alexander al (leiden)" , pgsql-admin@postgresql.org Date: Tue, 30 Apr 2024 10:50:44 +0200 In-Reply-To: <2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl> References: <2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2024-04-30 at 10:04 +0200, alexander al (leiden) wrote: > ecause gitlab next major upgrade needs a newer version of postgresql > we have to upgrade it. >=20 > now normally I would probably do 'upgrade' in the aws-console but on > aws rds PG 15 has a newer btree_gist version (1.7) >=20 > Are there any caveats concerning those extensions? That should be no problem. If the upgrade leaves the extension at its old version, you can update it to the latest version. At this time, I wouldn't upgrade to v15, but to v16. Yours, Laurenz Albe