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 1tIEkA-00D7Ft-9X for pgsql-general@arkaria.postgresql.org; Mon, 02 Dec 2024 22:18:14 +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 1tIEk7-0042zK-Bn for pgsql-general@arkaria.postgresql.org; Mon, 02 Dec 2024 22:18:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIEk6-0042zB-5K for pgsql-general@lists.postgresql.org; Mon, 02 Dec 2024 22:18:12 +0000 Received: from sonic315-21.consmr.mail.ne1.yahoo.com ([66.163.190.147]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tIEk4-000ilw-Av for pgsql-general@postgresql.org; Mon, 02 Dec 2024 22:18:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1733177886; bh=neonMK7zPi7to7RvgKluhTEddkO0rpskIxTh6Z/p9pA=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=kPjYiib+szJAGSJvaWBAVJssJ7r0ZwLVmrSI1e5q7rWsYXJDDCl/QFhmnDAteU8de/LhjnwRaZhfgoxO8QRGYLmWCcFU9+dhGS6jJt+pxoLsefJ9B+zd7+ho7MaENppuda7O2rwkileAxXM5rI8dCv+D3Yfu2D6NDsxA3srOeTiCJ60UTvl4SvSIJrrfLvNg4u0a0TtmDE2To6sbNsJZ/0AhBvPcEdmda39CFz83vqAephFFJArbttDaJ2eBNR7M2WARs2Hli5wWnNtk5Y83EaYfMp8lQrGB4kkYG6Xo8id/1qkWFOu380gQvGjPw4NrSQ9JRIBX3chjMp99Ntv5iA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1733177886; bh=rqDPe4yYNUAUrUADd5NenxRIj6F8IBJWEG7lgcOmIGn=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=cblXD4WeR74lFMZY7sSghtUzRak9K7AiFm8fobyGm9gD86Yyqt7sEjPq3H+oWGBJz/gKv6CLeNq8c04+StvM5E641yvEYmtmzmyyVDCtT26wSyMFLqjgYJzPJ9JZ41ngUGNNvF/Bp096NZpEZZUdq/kH5YlsuJseMQxtmmEjZm1dpo3ysRL1fBZrotrXW5UcncNQcgzPxlDh4MykCoZtbyn3b4Xv9B+YqD57+vuX+GhGLHRoVYTNpZ1GgG72s++U+KpfijIa0gVrAgAnLgWypSyCCs28Rvq5sKyLp1rV8WmQQXC6MvvmAtjvZiE1kqXv3nzAqq3tqr3/znHVQWGjHw== X-YMail-OSG: s38xnVoVM1mZsSEljRGPVfXyM4zftFYv35ttClImDTO3_Gf4TVWi2j.NkHzdqR4 z6IzBX9nyl3WGGX8Xb_JrwJ0KkR35yIgj8ZNzqTmWWgCH3jW8qp03xQOemN6QZEhLBxu13C6pSR. pXuaVkyxxyB2mSwds8cYmCRh5KGJaHRJJMrePqI_dwWZeRKfEkg_vBaxi6oBpYfAmAyBSD3vLfy0 _sO785oE1VllcGxuJvN6f4YLfXP.OKh2.k2xUxXjdgb5OwXaozH3rYgQSNeE6S_tsWrqMFtJ7hy8 Rkz9WMR7n8ZmCqo8JpZIYCrhEZvjvci00fppw_gYgfrNsZtHPN6_2hwHeyisZP2PPrYExY5rvPGd rZVbfxVTHRafHzJYO.q3buKx9Mrkip.Sy74OPOyTc_WWoGkqdaXETtkCux1WcpB90BmI.7_qrspA ilM8EALnR.nDy9eyl9OerRXkfrIGZV_qBCV9Lpya1SkB2o7l31.ViIAPwa4dI4i4u68peG15JfGR iwmODOdPkp6Z8Z6cBGE02OFMjEW.K.NZaALm91SDzBVvaaF4yI6ee64NZGFdSA2sbMGJD_TVwK9y AgbhdpyYqQMRhu6Iy.0B721OlBMlSctiPk69cTF.9tE4QEkLFpndZtxXPIbJn.4sifQYhTmygOXf eCcn3eU5bLux6UjI7xeIpJNMii8c11AeTlApwEJyD0PeH42waPhzx_lLLTuti78WpaIYb4EhhEKs ENJvO7ZlM2j2_7E7RRvaNphokBczNucu3Mvg0tgqLw..tkD90bjEM.Q5plvwPZDyW9PdHHjEs20G vA1vF9k5tQRSZ99uasdF7nNAaDB_VHHk3C3s7HEQ.iAE69ZZbCHR2BN3KpApjh3nMmJhGNglntie HEgwV28Sw3j_yF0VD.b5hcqrAvaX4OcrTOCkYalX6gwYrLLOmIKMgOXgWORrFDR75yE6Jb1Y9jxK w_nM1302r8OUe9XVRJK7PiWxa4QkkrtZxNT_ceheFts1zuExINi9YbCndtnkS.HTMJeEuB6HMvaU VscSW1COJc0ZHER5eB.P.Lf5rC3xcg_LsfN2DUM_mCrvWp1GKm1wQ07ZgdhbZSQTQXx.OP_.Z9eq yVdQrzqxPuHtDuFbtsuQw8s1meqn58.EUR2ZCMV4q.Lm.Dwr77prJMTUeKkToYAT5PRDIq3RBM8J cCxEElpUr5YFbmnHkIR9O0Va980E8GUY2UFUIvugI93zphMlkuM_rG5EWTI6MxAzyjo7KYYOWARa MfnJl226z_0UZ4Kty50xaYn2niWDYTUtGkhf7NbjIGTmoxD540nmTeEcLEGNDzjcuyct6M4ITMKR 7PaG5PLGINAy9YlnbhOCwL6QOa.2YOy1mDH66dwqMv2bD2S8d_zfevmf4OnniYfdBJXzyAvsySd7 P72ObL_j.jNQTNx7zp2crvxLWAIHiosX5tgHiIw1_mYvgZIydsMZ7ZseafUcb.V1FRsH_YvOWjlN k97D3lx.RTdy8yoTIlZoL8UEkECgy_WMBYgnRMnBbpDffvRQwcu.thWc4SvYQKC7mT.tKqq4t35. _7rLygHzPWB1evGGzD2pFtaA2ebNn6.oE90WQE7lhl.rBASkN7V68xWgQOSSyqrgZehs2VOl7K5i MdpM_WoubCmHTds7PxtICMgFWBd4Mxmq9Q5hGehfO.3f9UbNdaCxypOvJHMC2BwkPzQmdndVnhZP 6fc0PcF.qewldogneP3lGt.YUn2UvDmHWa8KBBp1_4amEdDysYymxHIwTGcwCS3VWMuHOsvUyP0p aIl2qf4RgCb2_79Pw_F8DroJSNWbglfrzwiIBizZlENGBd2golEL9AUWkSDwmtiDlYd3Rwhp3.JE zxK.fYmU39K0jALLIkbkm1iBwiNJnlqLoWokdzrC_tQdUOWRaXAzfaM_ktxPlnDAqafoaoHrymkY oY9MPd1xpJl_WV3ug3Om9yS1popgHB.iJDWjByiVOpRGLmnDmdXcSrGXN5juRAsTVGfy4rog72kn DiTAsCPSY6bePbqb_pT6AYnSd2jyyVVd3imjxMG1Jg.FiktUM398_nyHGggSB95TwkL.6AWZm_r2 iuJbbd5WeV7m5oOR6ielfuzAs9ZniYoYkKueqEqg5tGPjtYyDcrepTLGKS7pK5hb9yjEdTsW3U46 S8HnpfJiXNdJ0lJtj4cqBq2K1DDer416.6Nnqh1xcivX01YVndmaF4EAZftp5Z_XREEbDibT.J9m GStDqPzXT30C8KSOIjFo3m_RVrRj3gNlwf.XKD3fZCk_dOQpxrxQl2WNs5cTTzFkWxm11vOj_B2w Ejrrl X-Sonic-MF: X-Sonic-ID: e0f10092-602f-498b-a2a3-4d3bd1242b80 Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.ne1.yahoo.com with HTTP; Mon, 2 Dec 2024 22:18:06 +0000 Date: Mon, 2 Dec 2024 22:18:04 +0000 (UTC) From: Bharani SV-forum To: "pgsql-general@postgresql.org" Message-ID: <564950518.5117550.1733177884387@mail.yahoo.com> In-Reply-To: <98965993.3138805.1731699978332@mail.yahoo.com> References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <98965993.3138805.1731699978332@mail.yahoo.com> Subject: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5117549_1390463513.1733177884385" X-Mailer: WebService/1.1.22941 YMailNorrin Content-Length: 6603 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_5117549_1390463513.1733177884385 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable TeamPl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to v= er 15.X=20 Env =3D EC2 based Community PostgreSQL Ver 13.16.2=20 we will be performing upgrade of our EC2 server too along with new OS. Need help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver = 15.X=20 =C2=A0ASIS-existing server =3D EC2 with Community PostgreSQL Ver 13.16.2- e= nsure to capture all the pre.req meant for ver 15.10 are being met. - shutdown db.- take offline full backup (PG_DATA folder alone)=C2=A0 using= OS command Proposed-new EC2 server (with new Operating System version along Postgres V= er 15.10 Binaries)- install postgres 15.10 binaries- ensure to DISABLE auto= startup and shutdown of postgres 15.10-=C2=A0 Restore offline full backup= =C2=A0(PG_DATA folder alone) using OS command -=C2=A0 start performing pg_upgrade step to upgrade postgres from ver 13.16= .2 to 15.10 please guide me, if i have missed any steps in the abovesaid process To start new DB features, planning to rollout out the following feature's a= lone a) TLE extension for password complianceb) parallelize vacuum jobs to utili= ze -j option ------=_Part_5117549_1390463513.1733177884385 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Team
Pl Help in vetting my steps for Postgres DB upgr= ade from Ver 13.X to ver 15.X

Env =3D EC2 bas= ed Community PostgreSQL Ver 13.16.2

we will be perf= orming upgrade of our EC2 server too along with new OS.

N= eed help in vetting my steps for Postgres DB upgrade from Ver 1= 3.X to ver 15.X
 
ASIS-exist= ing server =3D EC2 with Community PostgreSQL Ver 13.16.2
- ensure to capture all the pre.req meant for ver 15.10= are being met.
- shutdown db.
=
- take offline full backup (PG_DATA folder alone)  us= ing OS command

=
Proposed-new EC2 server (with new Operating System version al= ong Postgres Ver 15.10 Binaries)
- install postgre= s 15.10 binaries
- ensure to DISABLE auto start= up and shutdown of postgres 15.10
-  Resto= re offline full backup (PG_DATA folder alone) = using OS command
-  start performing pg_upgrade step to upgrade postgres from ver 13.= 16.2 to 15.10

please guide me, if i have missed any steps in the abovesaid process

To start new DB= features, planning to rollout out the following feature's alone
=
a) TLE extension for password compliance
=
b) parallelize vacuum jobs to utilize -j option

------=_Part_5117549_1390463513.1733177884385--