Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Date
Msg-id CANzqJaBB9A-TUFEiyxUK3pYNyYGvAaKTcK31EkEb3VB+wf2d-A@mail.gmail.com
Whole thread Raw
In response to Postgres upgrade from 9.6.9 to postgresql 16 version  (Krishnaswamy <krishpostgresql@gmail.com>)
List pgsql-admin
Tree view
On Tue, Feb 13, 2024 at 11:23 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

 First, update to the latest patch version: 9.6.24.
 

pgsql-admin by date:

Previous
From: Chris Hoover
Date:
Subject: Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Next
From: Tom Lane
Date:
Subject: Re: pg_dump --binary-upgrade out of memory