Search Postgresql Archives

Re: upgrade postgres 9.5 to 9.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx>

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux