public inbox for [email protected]
help / color / mirror / Atom feedFrom: Eduardo Barbachan <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: Kushal Shri <[email protected]>
Cc: [email protected]
Subject: Re: PostgreSQL Upgrade (v9.5 to v12) with Django 2.0
Date: Fri, 13 Jun 2025 17:14:17 -0300
Message-ID: <CAGEDDz-9uaYihyW5hWYXj2XU+4khxQx+S9yJk5pnf-=+brMueA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAMSJNCXWkhYQ=YwSt+SQLT710+8KL3rRyb7Wo-fUerbr5o3idg@mail.gmail.com>
<[email protected]>
I'm sorry if this part of the answer should not be given in this context,
but I happen to be in this list (as a lurker for most of the time) and be a
Django user.
Till Django 4.2 (LTS) postgres 12 is supported. Django 5.2 (LTS also)
supports postgres 17+.
Em qui., 12 de jun. de 2025 às 10:19, Laurenz Albe <[email protected]>
escreveu:
> On Wed, 2025-06-11 at 16:39 +0545, Kushal Shri wrote:
> > 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.
>
> That's already wrong. PostgreSQL v12 is out of support. Upgrade to v17
> or v18.
>
> > As part of this, I would like to understand:
> >
> > - What is the highest PostgreSQL version reliably supported with Django
> 2.0?
>
> You'll have to ask Django what they support.
>
> > - What upgrade strategies or methods have worked well for you in similar
> environments?
>
> pg_upgrade --link
>
> > - Any gotchas or performance considerations to keep in mind with large
> databases
> > during such upgrades?
>
> Make sure you don't have millions of Large Objects, otherwise the upgrade
> will be very slow and memory consuming.
>
> Yours,
> Laurenz Albe
>
>
>
--
Att.
Eduardo Barbachan
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: PostgreSQL Upgrade (v9.5 to v12) with Django 2.0
In-Reply-To: <CAGEDDz-9uaYihyW5hWYXj2XU+4khxQx+S9yJk5pnf-=+brMueA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox