How Postgres Audit Tables Saved Us from Taking Down Production

• pgaudit

  5 1,183 5.0 C

  PostgreSQL Audit Extension

  

You can use pgaudit, it's an extension that let's you audit DDL/DML statements. It's a great auditing mechanism. I use it on all our prod postgres instances, but have only "DML" enabled, because of the potential performance overhead

https://github.com/pgaudit/pgaudit

• temporal_tables

  16 892 4.2 C

  Temporal Tables PostgreSQL Extension

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• debezium

  80 9,843 9.9 Java

  Change data capture for a variety of databases. Please log issues at https://issues.redhat.com/browse/DBZ.

  

An overkill-but-robust solution is Redhat's Debezium [1]. It works with multiple databases, but for Postgres specifically uses the logical decoding API that underpins replication. Changes are pushed into Kafka, or a custom app-specific connector.

https://github.com/debezium/debezium

• Embulk

  2 1,726 8.3 Java

  Embulk: Pluggable Bulk Data Loader.

  

Debezium is awesome, thanks for the great work! It's in my toolbox for when embulk [1] batch processing doesn't cut it.

https://github.com/embulk/embulk

Suggest a related project