From: Joshua D. Drake <jd@commandprompt.com>
To: bala jayaram <balajayaram22@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql9.4 aws - no pg_upgrade
Date: Sat, 14 Oct 2017 22:09:20 -0700
Message-ID: <5c0dd3a9-bee1-13ce-04aa-18571b12e5c4@commandprompt.com> (raw)
In-Reply-To: <CANcY5AxSwhtFFfUMCKpv-6sWHzzmd4c+jYJvT=4JadHwuTLkfA@mail.gmail.com>
References: <CANcY5AxSwhtFFfUMCKpv-6sWHzzmd4c+jYJvT=4JadHwuTLkfA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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. *****
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, balajayaram22@gmail.com
Subject: Re: postgresql9.4 aws - no pg_upgrade
In-Reply-To: <5c0dd3a9-bee1-13ce-04aa-18571b12e5c4@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox