Support for pgoutput plugin in addition to wal2json for Postgres CDC

[rkhameshra]

Hey 👋

Currently, OLake supports Postgres CDC using the wal2json output plugin. While wal2json works well and is easy to parse, we’ve seen growing interest in supporting the native pgoutput plugin as well, especially from users who already use it for replication or Debezium-style pipelines.

Adding pgoutput support could unlock:

• Lower overhead and native integration: Since pgoutput is the default plugin used by PostgreSQL logical replication.
• Better compatibility with tools like Debezium, and future interoperability with standard changefeed consumers.
• Improved performance in some cases, due to binary encoding and more compact WAL decoding.

We’d love to hear thoughts on this:

• Has anyone here run into limitations with wal2json in production?
• Would you prefer pgoutput over wal2json, and if so, why?
• Are there other output plugins you'd want us to support?

Would appreciate any feedback, use cases, or even pointers if someone has tried building a parser for pgoutput!

Thanks 🙌
— Team OLake