MIME-Version: 1.0
From: Kushal Shri <shrikushalk@gmail.com>
Date: Wed, 11 Jun 2025 16:39:54 +0545
Message-ID: 
 <CAMSJNCXWkhYQ=YwSt+SQLT710+8KL3rRyb7Wo-fUerbr5o3idg@mail.gmail.com>
Subject: PostgreSQL Upgrade (v9.5 to v12) with Django 2.0
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000523b12063749a5c6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMSJNCXWkhYQ%3DYwSt%2BSQLT710%2B8KL3rRyb7Wo-fUerbr5o3idg%40mail.gmail.com>
Precedence: bulk

--000000000000523b12063749a5c6
Content-Type: text/plain; charset="UTF-8"

Dear Community,

We are in the process of planning a PostgreSQL upgrade and would greatly
appreciate any insights, best practices, or lessons learned from your
experiences.

Current Setup:
   - PostgreSQL version: 9.5
   - Django version: 2.0
   - Database size: ~3 TB
   - One Master 4 Replicas(Streaming Replication)

We are taking a phased approach to this upgrade. In Phase 1, our goal is to
upgrade PostgreSQL from v9.5 to v12, ensuring compatibility with our
current Django 2.0 application.

As part of this, I would like to understand:

- What is the highest PostgreSQL version reliably supported with Django 2.0?
- What upgrade strategies or methods have worked well for you in similar
environments?
- Any gotchas or performance considerations to keep in mind with large
databases during such upgrades?

Your recommendations and experiences will be extremely valuable in helping
us plan and execute this upgrade smoothly.

Thank you in advance for your support!

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

<div dir=3D"ltr">Dear Community,<br><br>We are in the process of planning a=
 PostgreSQL upgrade and would greatly appreciate any insights, best practic=
es, or lessons learned from your experiences.<br><br>Current Setup:<br>=C2=
=A0 =C2=A0- PostgreSQL version: 9.5<br>=C2=A0 =C2=A0- Django version: 2.0<b=
r>=C2=A0 =C2=A0- Database size: ~3 TB<br>=C2=A0 =C2=A0- One Master 4 Replic=
as(Streaming Replication)<br><br>We are taking a phased approach to this up=
grade. In Phase 1, our goal is to upgrade PostgreSQL from v9.5 to v12, ensu=
ring compatibility with our current Django 2.0 application.<br><br>As part =
of this, I would like to understand:<br><br>- What is the highest PostgreSQ=
L version reliably supported with Django 2.0?<br>- What upgrade strategies =
or methods have worked well for you in similar environments?<br>- Any gotch=
as or performance considerations to keep in mind with large databases durin=
g such upgrades?<br><br>Your recommendations and experiences will be extrem=
ely valuable in helping us plan and execute this upgrade smoothly.<br><br>T=
hank you in advance for your support!</div>

--000000000000523b12063749a5c6--