<story><title>How to move from Amazon RDS to a dedicated PostgreSQL server</title><url>http://layer0.authentise.com/how-to-move-from-amazon-rds-to-dedicated-postgresql-server.html</url></story><parent_chain><item><author>craigkerstiens</author><text>Overall a nice post. It doesn&amp;#x27;t quite get into all the options for pg_dump as there&amp;#x27;s a number of other flags that can be useful to reduce downtime. It&amp;#x27;s also probably worth taking a look at Amazon Migration Service as well (though I haven&amp;#x27;t personally used it or heard from others that have yet) - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;aws.amazon.com&amp;#x2F;dms&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;aws.amazon.com&amp;#x2F;dms&amp;#x2F;&lt;/a&gt;.&lt;p&gt;One tool they did miss for continuous archiving is WAL-E, which tends to be the one most used including by us at Citus Cloud and Heroku Postgres - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;wal-e&amp;#x2F;wal-e&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;wal-e&amp;#x2F;wal-e&lt;/a&gt;</text></item></parent_chain><comment><author>chrisatumd</author><text>We&amp;#x27;ve tested out DMS to migrate from a 3 node Oracle RAC to Oracle RDS, and I was incredibly impressed. They list a bunch of limitations in their documentation that you should look at first. It migrated our roughly 1 TB database in two hours and ten minutes and handled replication flawlessly - not a single record discrepancy between the two database systems over a week long test. We were not expecting it to work that well and doubted that it would work with RAC as the source.</text></comment>
<story><title>How to move from Amazon RDS to a dedicated PostgreSQL server</title><url>http://layer0.authentise.com/how-to-move-from-amazon-rds-to-dedicated-postgresql-server.html</url></story><parent_chain><item><author>craigkerstiens</author><text>Overall a nice post. It doesn&amp;#x27;t quite get into all the options for pg_dump as there&amp;#x27;s a number of other flags that can be useful to reduce downtime. It&amp;#x27;s also probably worth taking a look at Amazon Migration Service as well (though I haven&amp;#x27;t personally used it or heard from others that have yet) - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;aws.amazon.com&amp;#x2F;dms&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;aws.amazon.com&amp;#x2F;dms&amp;#x2F;&lt;/a&gt;.&lt;p&gt;One tool they did miss for continuous archiving is WAL-E, which tends to be the one most used including by us at Citus Cloud and Heroku Postgres - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;wal-e&amp;#x2F;wal-e&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;wal-e&amp;#x2F;wal-e&lt;/a&gt;</text></item></parent_chain><comment><author>willlll</author><text>Yeah, I would* do a `pg_dump | pg_restore` with these settings: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;heroku&amp;#x2F;heroku&amp;#x2F;blob&amp;#x2F;master&amp;#x2F;lib&amp;#x2F;heroku&amp;#x2F;helpers&amp;#x2F;pg_dump_restore.rb#L65-L73&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;heroku&amp;#x2F;heroku&amp;#x2F;blob&amp;#x2F;master&amp;#x2F;lib&amp;#x2F;heroku&amp;#x2F;help...&lt;/a&gt;&lt;p&gt;*disclaimer: I wrote that code while at heroku</text></comment>