> This should be a very common setup in the field, so how are people doing it in practice?
One of possible workaround with archive and streaming was to use pg_receivexlog from standby to copy/save WALs to archive. but with pg_receivexlog was also issue with fsync.
[ master ] -- streaming --> [ standby ] -- pg_receivexlog --> [ /archive ]
In that case archive is always in pre standby state and it could be better than had archive broken on promote.
--
Misha