Postgres Pro
Downloads
Home   >   mailing lists

Re: update from 13 to16 - Mailing list pgsql-general

From Maciek Sakrejda
Subject Re: update from 13 to16
Date
Msg-id CAOtHd0DOajBNzOCt=y=-qFMWQip+g4u1E9wivL=sKtZvuFtBEA@mail.gmail.com
Whole thread Raw
In response to Re: update from 13 to16  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Fri, Sep 15, 2023, 15:02 Adrian Klaver <adrian.klaver@aklaver.com> wrote:

On 9/15/23 9:55 AM, Martin Mueller wrote:

I am thinking of upgrading from version 13 to version 16.

 

I think I can do this by leaving the data alone and just replacing the software.  My data are extremely simple and consist of several hundred

No you can't. 

You will need to either use pg_upgrade:

https://www.postgresql.org/docs/16/pgupgrade.html


To elaborate on this, if you want to avoid copying the data, you may want to take a look at pg_upgrade in link mode.

pgsql-general by date:

Previous
From: James Stuart
Date:
Subject: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?
Next
From: Tom Lane
Date:
Subject: Re: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?