Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1berPa-000568-BT for pgsql-admin@arkaria.postgresql.org; Tue, 30 Aug 2016 22:21:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1berPZ-0007Eo-Ro for pgsql-admin@arkaria.postgresql.org; Tue, 30 Aug 2016 22:21:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1berPX-0007EF-VI for pgsql-admin@postgresql.org; Tue, 30 Aug 2016 22:21:40 +0000 Received: from smtp98.iad3a.emailsrvr.com ([173.203.187.98]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1berPU-0005lJ-DO for pgsql-admin@postgresql.org; Tue, 30 Aug 2016 22:21:39 +0000 Received: from smtp13.relay.iad3a.emailsrvr.com (localhost [127.0.0.1]) by smtp13.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 192BBC04AF; Tue, 30 Aug 2016 18:21:27 -0400 (EDT) X-Auth-ID: jeff.frost@pgexperts.com Received: by smtp13.relay.iad3a.emailsrvr.com (Authenticated sender: jeff.frost-AT-pgexperts.com) with ESMTPSA id DA68AC03AC; Tue, 30 Aug 2016 18:21:25 -0400 (EDT) X-Sender-Id: jeff.frost@pgexperts.com Received: from [172.20.10.3] ([TEMPUNAVAIL]. [166.170.49.71]) (using TLSv1 with cipher DHE-RSA-AES256-SHA) by 0.0.0.0:587 (trex/5.7.7); Tue, 30 Aug 2016 18:21:27 -0400 Content-Type: multipart/alternative; boundary="Apple-Mail=_DF822512-422E-4A08-86CC-0A73BD14B16C" Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) Subject: Re: Rackspace to RDS - PostgreSQL 9.2 Migration Plan From: Jeff Frost In-Reply-To: Date: Tue, 30 Aug 2016 15:21:18 -0700 Cc: pgsql-admin Message-Id: References: To: Patrick B X-Mailer: Apple Mail (2.3124) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail=_DF822512-422E-4A08-86CC-0A73BD14B16C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On Aug 30, 2016, at 2:51 PM, Patrick B = wrote: >=20 >=20 >=20 > IIRC the DMS doesn't actually support 9.2, it requires 9.4 or newer I = believe. (You should double check that, my information might be old) >=20 > So you would have to start by upgrading your standalone cluster to 9.4 = or 9.5 (PostgreSQL itself has no problem going directly to 9.5), and = then use DMS to move it to RDS. >=20 >=20 >=20 > Hmm.. interesting.. yep.. I've just seen that DMS requires Postgres = 9.4 or above... >=20 >=20 > What about the time needed? Do you guys have any idea how long does it = take?=20 >=20 I tried migrating a 300GB postgresql 9.4 cluster from Rackspace to RDS = and it didn=E2=80=99t finish in 3 weeks, so we scrapped that plan and = used Bucardo to migrate it which finished overnight.= --Apple-Mail=_DF822512-422E-4A08-86CC-0A73BD14B16C Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
On Aug 30, 2016, at 2:51 PM, Patrick B <patrickbakerbr@gmail.com> wrote:



IIRC the DMS = doesn't actually support 9.2, it requires 9.4 or newer I believe. (You = should double check that, my information might be old)

So you would have to = start by upgrading your standalone cluster to 9.4 or 9.5 (PostgreSQL = itself has no problem going directly to 9.5), and then use DMS to move = it to RDS.



Hmm.. interesting.. yep.. I've just = seen that DMS requires Postgres 9.4 or above...


What= about the time needed? Do you guys have any idea how long does it = take? 



I tried migrating a 300GB postgresql = 9.4 cluster from Rackspace to RDS and it didn=E2=80=99t finish in 3 = weeks, so we scrapped that plan and used Bucardo to migrate it which = finished overnight.
= --Apple-Mail=_DF822512-422E-4A08-86CC-0A73BD14B16C--