9 ms·
Back in my SQL Server days they had something called "log shipping" which is basically sending the transaction log over the wire to another machine where it is
by pmarreck 9y ago
Back in my SQL Server days they had something called "log shipping" which is basically sending the transaction log over the wire to another machine where it is re-run. Does that still exist?
EDIT: It turns out there is https://www.postgresql.org/docs/9.1/static/warm-standby.html https://www.postgresql.org/docs/9.1/static/warm-standby.html and this seems to accomplish the same goal without actually being replication, so what gives?
- tapoxi 9y agoI think warm standby is a relatively new feature for Postgres. As someone who's had to configure warm standby recently, it's fine, but it's not active-active, which infuriated a few Oracle DBA colleagues. The best way to do that at the moment is by using a proxy like PgPool II.