Re: Upgrading from Postgresql 9.1 to 10

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrading from Postgresql 9.1 to 10
Date: 2018-02-14 14:47:55
Message-ID: CAKFQuwZWz+4zmhTQ=VEDE9hnCP9Fa=Xx=PoOPowm0yX9zGjkWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, February 14, 2018, pavan95 <pavan(dot)postgresdba(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Teja 2018-02-14 14:51:03 Re: Upgrading from Postgresql 9.1 to 10
Previous Message Melvin Davidson 2018-02-14 14:47:24 Re: Upgrading from Postgresql 9.1 to 10