Tracking changes in data in Aurora PostgreSQL
0
Customer is looking for ways to track changes in their data in Aurora PostgreSQL.
Traditionally they could add a date created, date_modified, username etc columns directly into each table and use it as a reference.
Any suggestions of a way they could cut down on having to do this for each table and instead consume some audit/WAL logs for each row change? Or ideas on how others are tackling this use case?
Topics
asked 2 years ago6 views
1 Answers
0
Accepted Answer
We developed the Database Activity Streams feature for this use case. It's along the lines of pgaudit, but is a managed feature of RDS/Aurora that encrypts events with the customer's key and then streams them to Kinesis. Check it out and let us know what you think!
answered 2 years ago
Relevant questions
Aurora PostgreSQL write forwarding
Accepted Answerasked 2 years agoHow to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?
asked a day agoTracking changes in data in Aurora PostgreSQL
Accepted Answerasked 2 years agoChanges to connection handling with Aurora Postgres?
Accepted Answerasked 3 years agoUse Aurora Postgresql as Datamart for Redshift
Accepted Answerasked 3 years agoAurora PostgreSQL Replica Pricing
asked 2 years agoInvoke lamda async from Aurora PostgreSQL
Accepted Answerasked 2 years agoParallel load support in aws_s3 extension to import data in Aurora PostgreSQL
Accepted AnswerAurora PostgreSQL - recommended maximum number of databases (for a multi-tenant data layer)
Accepted Answerasked 3 years agoMajor Version Upgrade Aurora PostgreSQL 11
asked 2 years ago