How would this work from a fault tolerance perspective? For example the listening application happens to be offline but the database is inserting records. How would the application catch up?
The application can catch up when restarted, if it retains the last WAL position. When it restarts, can asks Postgres to start replaying from that point.
but, disk isn't usually infinite.
I had imagined the GP might have been insinuating something like: a configurable number of WAL files would be written, then they'll be overwritten once all full.