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?
질문됨 4년 전1795회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
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!
답변함 4년 전
