Re: Postgres upgrade from 9.6.9 to postgresql 16 version

Поиск
Список
Период
Сортировка
От Krishnaswamy
Тема Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Дата
Msg-id CAE6DLLJAc8pTBUyBP1_v-21BBGr7bVz=4Scd6WSf1S6dEYU=Fg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres upgrade from 9.6.9 to postgresql 16 version  (Chris Hoover <chrish@aweber.com>)
Ответы Re: Postgres upgrade from 9.6.9 to postgresql 16 version  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Regarding cve-2024-0985
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Postgres upgrade from 9.6.9 to postgresql 16 version