Do you have an idea or suggestion based on your experience with Azure Database for PostgreSQL?

Ability to output data changes via logical decoding (ex. wal2json)

PostgreSQL, since 9.4, has the ability to provide the list of changes made to a database in a manner that is transaction-safe and lossless.

To enable this feature, the wal_level needs to be set to logical and there needs to be an available output plugin. Unfortunately, PostgreSQL only comes with the test_decoding plugin, which was only really meant as an example.

AWS for example, has included wal2json support:

https://aws.amazon.com/about-aws/whats-new/2017/07/amazon-rds-for-postgresql-supports-new-minor-versions-9-6-3-and-9-5-7-and-9-4-12-and-9-3-17/

The simple wal2json output plugin would be a good way to provide access to this powerful feature for a wide audience.

I'd also be fine with other output plugins. It may be worth noting that there has been some discussion about including wal2json in the standard set of contrib plugins.

Looking forward to having some way to get this CDC data out of PostgreSQL with this great feature.

30 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Patrick Earl shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base