We are working on building a ETL pipeline. And I have come across these two plugins for postgres to capture the writes and deletes of the table.

Can someone please explain the differences between Wal2json and Pgoutput? What are the pros/cons and performance impact if there are any?

Basically I want to understand when to use among these two plugins in Postgres.

Thanks in advance

CodePudding user response：

They are for different purposes. pgoutput is for use with logical replication between PostgreSQL databases, wal2json is for getting a JSON representation of data modifications for use with third-party applications.