3 ms·
We ran PostgreSQL in production before 2010, and there were several solutions back then for replication but all of them had their own set of problems. We went w
by jeltz 13y ago
We ran PostgreSQL in production before 2010, and there were several solutions back then for replication but all of them had their own set of problems. We went with shipping the write-ahead log with rsync to the standby server, but this was trickier to set up and had much worse latency than the current built-in solution (which is basically streaming the write-ahead log over a tcp connection).