TL;DR; Yes, it works.

Proof: SearchReplica You can stream changes from Postgres, and injest the data in any external database, like regular postgres replica does. Using Postgres replication functionality to keep data consistent, and almost realtime.

This would be start of series of posts, regarding pitfalls, mistakes and details of logical decoding. ToC: TBD;

You work with Postgress as database. Stream WAL (with logical decoding) into Elasticsearch. And use Elastic for search.