Logical Decoding

[Sri Krishna Paritala]

Hi,

We want to use logical decoding to read and push any changes to our database into data processing pipelines. I've tried doing it as documented in the official Postgres docs for 9.6. But cloud sql is disallowing me to change the wal_level to logical. I've looked for this in other providers and Amazon RDS already provides this and has a blog posted about it here.

Is there a way do this already? If yes then can you point me to the documentation?

If there isn't is it part of the roadmap?

[George (Cloud Platform Support)]

Hello Sri Krishna, 

You are right, there is work in progress on exactly the same issue; you may follow title "Change the wal_level to logical for logical decoding" in Issue Tracker. 

It may be worthwhile mentioning here that, not surprisingly, this feature is present for instances deployed in Compute Engine; details on the "How to Set Up PostgreSQL for High Availability and Replication with Hot Standby" page.