Re: update from 13 to16

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: update from 13 to16
Дата
Msg-id CAOtHd0DOajBNzOCt=y=-qFMWQip+g4u1E9wivL=sKtZvuFtBEA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: update from 13 to16  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: James Stuart
Дата:
Сообщение: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?