MIME-Version: 1.0
From: Zaid Shabbir <zaidshabbir@gmail.com>
Date: Thu, 30 May 2024 23:10:28 +0500
Message-ID: 
 <CABCJe_V=rzBv4koouirYuNqC=0fuBz=jhf0Wns63uJj895VvOg@mail.gmail.com>
Subject: Remove Cluster forcefully during the check_upgrade failure
To: pgsql-pkg-yum@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d1d8df0619afc880"
Archived-At: 
 <https://www.postgresql.org/message-id/CABCJe_V%3DrzBv4koouirYuNqC%3D0fuBz%3Djhf0Wns63uJj895VvOg%40mail.gmail.com>
Precedence: bulk

--000000000000d1d8df0619afc880
Content-Type: text/plain; charset="UTF-8"

Hello,

I have installed PostgreSQL 15 and PostgreSQL 14 side by side and want to
upgrade from 14 to 15. For upgrading purposes, I am using {postgresql-15-setup
check_upgrade}. However, in my case, the installed 14 version is not
compatible with the latest 15.7.

After the installation and cluster initialization of PostgreSQL 14 and 15,
when I run the following command {postgresql-15-setup check_upgrade}, it
returns the following message:
"Performing upgrade check: Upgrade failed. Removing the new cluster. Please
re-initdb the new cluster. failed "


After the failure the postgresql15 cluster removed forcefully due to the
following code written in postgresql-15-setup script file

{
if [ $script_result -eq 0 ]; then
        echo $"OK"
    else
        # Clean up after failure
        echo "Upgrade failed. Removing the new cluster. Please re-initdb
the new cluster."

*        rm -rf "$PGDATA"*        echo $"failed"
fi
}

My concern here is whether forcefully deleting the user cluster without
obtaining permission from the user is the right approach.


Regards,
Zaid Shabbir
AGEDB

--000000000000d1d8df0619afc880
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div><p style=3D"color:rgb(0,0,0)">I =
have installed PostgreSQL 15 and PostgreSQL 14 side by side and want to upg=
rade from 14 to 15. For upgrading purposes, I am using<span class=3D"gmail-=
Apple-converted-space">=C2=A0</span><code>{postgresql-15-setup check_upgrad=
e}</code>. However, in my case, the installed 14 version is not compatible =
with the latest 15.7.</p><p style=3D"color:rgb(0,0,0)">After the installati=
on and cluster initialization of PostgreSQL 14 and 15, when I run the follo=
wing command<span class=3D"gmail-Apple-converted-space">=C2=A0</span><code>=
{postgresql-15-setup check_upgrade}</code>, it returns the following messag=
e:</p></div>&quot;Performing upgrade check: Upgrade failed. Removing the ne=
w cluster. Please re-initdb the new cluster. failed &quot;<div><br></div><d=
iv><br></div><div>After the failure the postgresql15 cluster removed forcef=
ully due to the following code=C2=A0written in=C2=A0postgresql-15-setup scr=
ipt file</div><div><br></div><div>{</div><div>if [ $script_result -eq 0 ]; =
then<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 echo $&quot;OK&quot;<br>=C2=A0 =C2=A0 e=
lse<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 # Clean up after failure<br>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 echo &quot;Upgrade failed. Removing the new cluster. Plea=
se re-initdb the new cluster.&quot;<br><b><font color=3D"#ff0000">=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 rm -rf &quot;$PGDATA&quot;<br></font></b>=C2=A0 =C2=A0=
 =C2=A0 =C2=A0 echo $&quot;failed&quot;<br>fi</div><div>}</div><div><br></d=
iv>My concern here is whether forcefully deleting the user cluster without =
obtaining permission from the user is the right approach.<div><br></div><di=
v><br></div><div><br><div>Regards,</div><div>Zaid Shabbir</div><div>AGEDB<b=
r><div><br></div></div></div></div>

--000000000000d1d8df0619afc880--