Amazon Aurora PostgreSQL, combined with pgAudit extension and Database Activity Streams, can provide auditing and change history capabilities to replace Amazon Quantum Ledger Database (QLDB) for certain use cases, enabling secure and cost-effective auditing for PostgreSQL-compatible workloads.

<div>
<p>The article discusses how Amazon Aurora PostgreSQL can replace Amazon QLDB for audit use cases. It highlights the key features of Aurora PostgreSQL that can provide similar auditing capabilities as QLDB.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Replacing the immutable journal in QLDB with PostgreSQL audit logging and storing logs in Amazon CloudWatch Logs or Amazon S3</li>
<li>Replacing QLDB's history() function with audit tables in PostgreSQL, mirroring the structure of the main table or storing audit data as JSON</li>
<li>Replacing QLDB streams with AWS Database Migration Service for data replication and Database Activity Streams for near real-time auditing, coupled with Amazon Kinesis and Amazon S3</li>
<li>Conclusion: Aurora PostgreSQL can provide auditing capabilities similar to QLDB through various AWS services and features</li>
</ul>
</div>


Related articles