跟踪Aurora PostgreSQL数据库中的数据变化

0

【以下的问题经过翻译处理】客户正在寻找一种方法来跟踪Aurora PostgreSQL中数据的更改。

传统方法是在每个表中直接添加日期创建、日期修改、用户名等字段，并将其用作参考。

是否有一种方法可以避免为每个表都这样做，而是消耗一些审核/ WAL日志来跟踪每行更改？或者有其他人是如何处理这种使用情况的？

Topics

Tags

PostgreSQL Aurora PostgreSQL

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 8 months ago9 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

【以下的回答经过翻译处理】我们为此用例开发了Database Activity Streams功能。这类似于pgaudit，但是它是RDS / Aurora的托管功能，可使用客户的密钥加密事件，然后将其流式传输到Kinesis。请查看并让我们知道您的想法！

EXPERT

rePost Polyglot

answered 8 months ago

Relevant content

Sites on Amplify become very slow recently. Amplify站点最近突然变得很慢。
Zhu
asked 10 months ago
S3上无法使用Chunked上传文件｜ Unable to use Chunked to upload files on S3
rePost-User-1798329
asked a year ago
使用finalshell 链接老是中断或无法链接
rePost-User-9459845
asked a year ago
sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
How do I connect to my Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL using IAM authentication?
AWS OFFICIALUpdated a year ago
How can I migrate from an RDS for PostgreSQL to Aurora PostgreSQL?
AWS OFFICIALUpdated a year ago
How can I create an Aurora PostgreSQL-Compatible global database?
AWS OFFICIALUpdated a year ago
Why did my Amazon Aurora PostgreSQL-Compatible cluster failover?
AWS OFFICIALUpdated a year ago
[Action Required] Upgrade Amazon Aurora PostgreSQL 11.13, 11.14, 11.15, 12.8, 12.10, 13.4, 13.5, and 13.6 minor versions by September 15, 2023
EXPERT
AWS-AdamLevin
published a year ago
Amazon Redshift rsql with PostgreSQL psql
EXPERT
Jon Roberts
published 5 months ago