On 10/14/2017 08:53 PM, bala jayaram 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?
Look into the -j option with pg_dump/pg_restore
JD
Thanks
Balaji Jayaraman
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
***** Unless otherwise stated, opinions are my own. *****
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
