Would standard postgres streaming replication do what you are looking for? https://wiki.postgresql.org/wiki/Streaming_Replication https://wiki.postgresql.org/wi

Would standard postgres streaming replication do what you are looking for? https://wiki.postgresql.org/wiki/Streaming_Replication https://wiki.postgresql.org/wiki/Streaming_Replication We use a combination of streaming replication and wal-e backups. A separate machine performs multiple restores per hour and verifies restores work ok and that the data is recent.