Re: Postgres upgrade from 9.6.9 to postgresql 16 version

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Date: 2024-02-13 17:26:50
Message-ID: CANzqJaBB9A-TUFEiyxUK3pYNyYGvAaKTcK31EkEb3VB+wf2d-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Feb 13, 2024 at 11:23 AM Krishnaswamy <krishpostgresql(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2024-02-13 18:30:08 Re: pg_dump --binary-upgrade out of memory
Previous Message Chris Hoover 2024-02-13 16:27:25 Re: Postgres upgrade from 9.6.9 to postgresql 16 version