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 <sscott...@gmail.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 <akumar14...@gmail.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 <sscott...@gmail.com> >
