Subject: Re: postgresql9.4 aws - no pg_upgrade
To: bala jayaram <balajayaram22@gmail.com>, pgsql-admin@postgresql.org
References: 
 <CANcY5AxSwhtFFfUMCKpv-6sWHzzmd4c+jYJvT=4JadHwuTLkfA@mail.gmail.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
Message-ID: <5c0dd3a9-bee1-13ce-04aa-18571b12e5c4@commandprompt.com>
Date: Sat, 14 Oct 2017 22:09:20 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.3.0
MIME-Version: 1.0
In-Reply-To: 
 <CANcY5AxSwhtFFfUMCKpv-6sWHzzmd4c+jYJvT=4JadHwuTLkfA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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