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@xxxxxxxxxx> 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@xxxxxxxxx> 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
