Re: upgrade postgres 9.5 to 9.6

May you provide me steps to perform it (logical replication upgrade).

I will be thankful to you.

Regards
Atul

On Friday, January 15, 2021, Enrico Pirozzi <sscotty71(at)gmail(dot)com> wrote:

> Hi Atul,
> you could use logical replication and do an hot upgrade between the 2
> servers with a zero downtime ;)
>
> If you want to use logical replication between a 9.5 , 9.6 version you
> could use for example pglogical.
>
> You could achieve the same result using an external logic replication tool
> like slony, although pglogical is more powerful.
>
> I hope that this can help you
>
> Regards,
> Enrico
>
> On Fri, 15 Jan 2021 18:47:51 +0530
> Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
>
> > Hi,
> >
> > I want to upgrade my server from postgres 9.5 to 9.6, but my DB size
> > is in TBs and I want to do it in minimum downtime (2-3 hours) so
> > please help me how should I perform it.
> >
> >
> > Please share the document, if possible, it will be grateful.
> >
> >
> >
> > Regards,
> > Atul
>
> --
> Enrico Pirozzi <sscotty71(at)gmail(dot)com>
>