> 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