| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | bala jayaram <balajayaram22(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgresql9.4 aws - no pg_upgrade |
| Date: | 2017-10-15 05:09:20 |
| Message-ID: | 5c0dd3a9-bee1-13ce-04aa-18571b12e5c4@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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. *****
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl Denninger | 2017-10-15 15:37:04 | Tsearch2 removal bit me - how to correct? |
| Previous Message | bala jayaram | 2017-10-15 03:53:31 | postgresql9.4 aws - no pg_upgrade |