Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres upgrade from 9.6.9 to postgresql 16 version - Mailing list pgsql-admin

From Krishnaswamy
Subject Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Date
Msg-id CAE6DLLJAc8pTBUyBP1_v-21BBGr7bVz=4Scd6WSf1S6dEYU=Fg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres upgrade from 9.6.9 to postgresql 16 version  (Chris Hoover <chrish@aweber.com>)
Responses Re: Postgres upgrade from 9.6.9 to postgresql 16 version
List pgsql-admin
Tree view
Hi All

As per the documentation wal_level= logical supported in 9.6 version.

Can we use logical replication in that use to upgrade.

But the issue here is test_decoding plugin seems to be missing in the library..is it possible to install manually the plugin...please let me know any refer links or steps for that.... 



Thanks
Krishnaswamy 

On Tue, Feb 13, 2024, 9:57 PM Chris Hoover <chrish@aweber.com> wrote:
We went from 9.0 -> v15 in a single step.  We used Londiste to do the replication.  It’s older technology, but made upgrading in a single move possible.  DB is +2TB.  We had about 1 hr of downtime between final steps and validation of our applications.

Thanks,


Chris Hoover
Senior DBA
AWeber.com
Cell: (803) 528-2269



On Feb 13, 2024, at 11:22 AM, Krishnaswamy <krishpostgresql@gmail.com> wrote:

Hi All 

We have a postgreSQL db with version 9.6.9 version and planning to upgrade to latest postgresql 16 version.

Database size is around 4 TB .

Please suggest  
1) options/methods to upgrade 
2) best practices to note while doing this much major version upgrade

Thanks
Krishnaswamy 



pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Regarding cve-2024-0985
Next
From: Laurenz Albe
Date:
Subject: Re: Postgres upgrade from 9.6.9 to postgresql 16 version