Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading from Postgresql 9.1 to 10 - Mailing list pgsql-general

From David G. Johnston
Subject Re: Upgrading from Postgresql 9.1 to 10
Date
Msg-id CAKFQuwZWz+4zmhTQ=VEDE9hnCP9Fa=Xx=PoOPowm0yX9zGjkWQ@mail.gmail.com
Whole thread Raw
In response to Upgrading from Postgresql 9.1 to 10  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: Upgrading from Postgresql 9.1 to 10  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Upgrading from Postgresql 9.1 to 10  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Tree view
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.

David. J.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Upgrading from Postgresql 9.1 to 10
Next
From: Pavan Teja
Date:
Subject: Re: Upgrading from Postgresql 9.1 to 10