Обсуждение: Postgres upgrade from 9.6.9 to postgresql 16 version
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
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
Email: chrish@aweber.com
On Feb 13, 2024, at 11:22 AM, Krishnaswamy <krishpostgresql@gmail.com> wrote:Hi AllWe 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 suggest1) options/methods to upgrade2) best practices to note while doing this much major version upgradeThanksKrishnaswamy
On Tue, Feb 13, 2024 at 11:23 AM Krishnaswamy <krishpostgresql@gmail.com> wrote:
Hi AllWe 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 suggest1) options/methods to upgrade2) best practices to note while doing this much major version upgrade
First, update to the latest patch version: 9.6.24.
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.On Feb 13, 2024, at 11:22 AM, Krishnaswamy <krishpostgresql@gmail.com> wrote:Hi AllWe 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 suggest1) options/methods to upgrade2) best practices to note while doing this much major version upgradeThanksKrishnaswamy
On Fri, 2024-02-16 at 13:27 +0530, Krishnaswamy wrote: > 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.... You cannot use logical replication with version 9.6. test_decoding is just for testing and cannot help with logical replication. Yours, Laurenz Albe