pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: David Gauthier <dfgpostgres@gmail.com>
To: Yogesh Sharma <yogesh.sharma@catprosystems.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: v11.5- v15.3 upgrade (linux)
Date: Fri, 8 Mar 2024 09:09:52 -0800
Message-ID: <3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com> (raw)
In-Reply-To: <CAEs=6DnSP3-tJh40S3Xiy3FEX_ufg_+rKr1C5xREBmfZxeO2wg@mail.gmail.com>
References: <CAEs=6D=T+eAj7GJZiNz6_o60OqAYmy4xd9jJ1tbqcp+X17etPA@mail.gmail.com>
	<88132f81-7e82-4d53-a55a-eede564351da@catprosystems.com>
	<CAEs=6DnSP3-tJh40S3Xiy3FEX_ufg_+rKr1C5xREBmfZxeO2wg@mail.gmail.com>

On 3/8/24 08:57, David Gauthier wrote:
> Thanks for the reply.
> 
> When you say "dump/restore" do you mean pg_dump then running the 
> resulting SQL into the destination DB?
> I like the replication option myself best (min downtime), especially as 
> we use a DB alias for connections.  But I don't think I'll be able to 
> sell that to the IT group.

You said the dump/restore has been tested.

How long did that take?

> 
> Regarding the safety of running a "drop extension plperlu cascade" on 
> the v11.5, would you consider that to be safe GIVEN that there are no 
> plperlu procs that it will affect?  I need to be able to tell IT that 
> I'm not the only one who thinks that it's safe.

BEGIN;

DROP LANGUAGE plperlu;

ROLLBACK;

See if the above complains about anything depending on it.

If not:

DROP EXTENSION plperlu;

> 
> 
> 
> On Fri, Mar 8, 2024 at 11:28 AM Yogesh Sharma 
> <yogesh.sharma@catprosystems.com 
> <mailto:yogesh.sharma@catprosystems.com>> wrote:
> 
>     Greetings,
> 
>     On 3/6/24 19:19, David Gauthier wrote:
>      > Hi:
>      > I'm a PG user in a big corp with an IT dept that administers a PG
>      > server/instance that I use.  It's an old install, v11.5, and we need
>      > to upgrade to v15.3.  They want to bring the upgraded DB up on a new
>      > linux vm which has OS upgrades of its own.  So it's a move AND an
>      > upgrade. There are 2 concerns....
>      >
>      > First has to do with a jump from 11.5 - 15.3 ?  Is it safe to do
>     this
>      > given so many major intermediate versions being skipped ?
> 
>     Generally speaking, it is safe from database point of view but you have
>     to verify that application is working as expected with PostgreSQL 15,
>     driver update, any query performance issues, any deprecate features in
>     use, collation differences, and performance verification, etc.
> 
>     PostgreSQL supports dump/restore (slow and longer downtime), binary
>     upgrade using pg_upgrade (faster and low downtime), and logical
>     replication (complex and least downtime). Since OS upgrade is also part
>     of the equation, dump/restore or logical  are better candidates. Due to
>     OS collation difference I would avoid binary upgrade path.
> 
> 
>     -- 
>     Kind Regards,
>     Yogesh Sharma
>     PostgreSQL, Linux, and Networking Expert
>     Open Source Enthusiast and Advocate
>     PostgreSQL Contributors Team @ RDS Open Source Databases
>     Amazon Web Services: https://aws.amazon.com <https://aws.amazon.com;
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com






view thread (11+ messages)  latest in thread

Message-ID: <3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com>
Permalink:  ../3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com/
Also on:    postgresql.org/message-id/3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: adrian.klaver@aklaver.com, dfgpostgres@gmail.com, yogesh.sharma@catprosystems.com
  Subject: Re: v11.5- v15.3 upgrade (linux)
  In-Reply-To: <3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com>
  References: <CAEs=6D=T+eAj7GJZiNz6_o60OqAYmy4xd9jJ1tbqcp+X17etPA@mail.gmail.com> <88132f81-7e82-4d53-a55a-eede564351da@catprosystems.com> <CAEs=6DnSP3-tJh40S3Xiy3FEX_ufg_+rKr1C5xREBmfZxeO2wg@mail.gmail.com> <3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox