Re: Upgrading from Postgresql 9.1 to 10

On Wed, Feb 14, 2018 at 10:04 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

>
>
> On Wednesday, February 14, 2018, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> 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.
>>
>>
> 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.
>

> To clarify, you need to use logical replication here since the WAL format
is not usable across versions.
Slony replication also allows upgrading between versions without downtime.

http://www.slony.info/
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.