Lol ; I was currently building something quite similar with vibe coding.

Using pgx + pglogrepl in Golang read logical changes - pgoutput Insert into s3 tables.

Advantage here is that we run everything on AWS, and can't install certain extensions in postgres itself.

+ Every little cpu I can save of postgres would want that.