Amazon QLDB ledgers can be migrated to Amazon Aurora PostgreSQL by exporting the ledger data, transforming it into CSV format using AWS Glue, and loading it into Aurora PostgreSQL using AWS DMS, with ongoing changes replicated from QLDB streams to Aurora via Amazon Kinesis and AWS Lambda.

<div>
<p>This article discusses how to migrate data from an Amazon QLDB ledger to an Amazon Aurora PostgreSQL database.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Migration decisions (e.g., whether to migrate all historical data or just recent data)</li>
<li>Solution overview (full data load and ongoing replication phases)</li>
<li>Prerequisites (setting up source QLDB ledger and target Aurora PostgreSQL database)</li>
<li>Exporting data from QLDB to S3</li>
<li>Extracting and transforming data using AWS Glue</li>
<li>Full data migration to Aurora PostgreSQL using AWS DMS</li>
<li>Ongoing change data replication from QLDB to Aurora using Kinesis and Lambda</li>
<li>Cleaning up resources</li>
<li>Adapting the solution for your own ledger</li>
</ul>
</div>


Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL

Related articles

Related articles

Jul 18
2024
Replace Amazon QLDB with Amazon Aurora PostgreSQL for audit use cases

Jul 1
2024
AWS DMS homogenous migration from PostgreSQL to Amazon Aurora PostgreSQL

Jun 10
2026
How to migrate from Oracle to Amazon Aurora PostgreSQL using AWS CloudFormation (Part 1)

Jun 3
2026
Migrating data from Oracle to Amazon Aurora DSQL