But i came to know that there is no pg_upgrade binary available from amazon repositories.
Just for future reference, you don't *have* to use a packaged version of pg_upgrade. You could compile postgres binaries from source in a temp location, use that pg_upgrade to upgrade your database, and then remove the compiled folder and use the packaged binaries to manage the new cluster.
i want to upgrade my current aws ec2 postgresql9.3 to AWS RDS 9.4 server.
Probably better to move to 9.6 at this point, or 10.1(which will be releasing soon)
Payal
On Sat, Oct 14, 2017 at 11:53 PM, bala jayaram <balajayaram22@xxxxxxxxx> wrote:
i want to upgrade my current aws ec2 postgresql9.3 to AWS RDS 9.4 server.so i would like to use pg_upgrade feature to convert 9.3 to 9.4 within EC2 instance for using amazon DMS (database migration service) utility. But i came to know that there is no pg_upgrade binary available from amazon repositories. Taking pg_dump from EC2 instance to RDS will take longer time, as our DB size is 300GB. Is there a way with less downtime for migrating existing EC2 9.3 to RDS?ThanksBalaji Jayaraman
