PostegreSQL 9.2 to 9.6

Started by drum.lucas@gmail.comabout 6 years ago2 messagesgeneral
Jump to latest
#1drum.lucas@gmail.com
drum.lucas@gmail.com

Hi guys.

We need to upgrade (asap) our PostgreSQL 9.2 cluster. We run our cluster on
AWS EC2 instances, and want to upgrade to RDS 9.6. Once in RDS, it makes
easier for us to major upgrade to 11.

Since this upgrade must be done with minimal downtime, my original idea was
to use Bucardo <https://bucardo.org/Bucardo/&gt;.

Does anybody have any better idea? please share.
Just wanna make sure I'm going on the right path.

Cluster size is 2TB.

Cheers
Lucas

#2Enrico Pirozzi
sscotty71@gmail.com
In reply to: drum.lucas@gmail.com (#1)
Re: PostegreSQL 9.2 to 9.6

Hi Lucas I've made it, from 9.2 to 12.2 using slony and it worked very
well :)

Enrico

Il sab 28 mar 2020, 13:29 Lucas Possamai <drum.lucas@gmail.com> ha scritto:

Show quoted text

Hi guys.

We need to upgrade (asap) our PostgreSQL 9.2 cluster. We run our cluster
on AWS EC2 instances, and want to upgrade to RDS 9.6. Once in RDS, it makes
easier for us to major upgrade to 11.

Since this upgrade must be done with minimal downtime, my original idea
was to use Bucardo <https://bucardo.org/Bucardo/&gt;.

Does anybody have any better idea? please share.
Just wanna make sure I'm going on the right path.

Cluster size is 2TB.

Cheers
Lucas