Re: Postgres upgrade from 9.6.9 to postgresql 16 version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

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



On Feb 13, 2024, at 11:22 AM, Krishnaswamy <krishpostgresql@xxxxxxxxx> 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 



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux