Re: Upgrading from Postgresql 9.1 to 10

Поиск
Список
Период
Сортировка
От Pavan Teja
Тема Re: Upgrading from Postgresql 9.1 to 10
Дата
Msg-id CACh9nsa71VW-9PV__3TutZPFk6_QeqjyPQa8cnrm01djPZUxjg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Upgrading from Postgresql 9.1 to 10  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Yeah David,

Even I'm thinking the same

Regards,
Pavan

On Feb 14, 2018 8:34 PM, "David G. Johnston" <david.g.johnston@gmail.com> wrote:


On Wednesday, February 14, 2018, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, February 14, 2018, pavan95 <pavan.postgresdba@gmail.com> wrote:
Hi all,

Is it possible to upgrade an existing postgresql 9.1 production system to
latest Postgres 10.0 version?

The main requirement is to get rid of downtime. Please help me out!

Zero downtime is only possible by standing up a hot-standby then failing over to it.  Same-server upgrade you can do via pg_upgrade but it does involve downtime.  There are lots of material and options online, including the docs, for setting up hot-standby replication.


To clarify, you need to use logical replication here since the WAL format is not usable across versions.

pg_upgrade is your simplest option if you can handle its downtime.

David J. 

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Upgrading from Postgresql 9.1 to 10
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Upgrading from Postgresql 9.1 to 10