3 ms·
I think 9.0 might be addressing it, but lack of replication has been a feature I've missed a fair bit. Shipping WAL files over rsync seems a little.. hackey to
by agentultra 16y ago
I think 9.0 might be addressing it, but lack of replication has been a feature I've missed a fair bit.
Shipping WAL files over rsync seems a little.. hackey to me. Worse still, Postgres has to load the entire WAL on the slave when it wakes (whereas with Oracle you can query the slave before it has finished loading the WAL files since it can pause and continue).
Disclosure: I'm not a DBA or specialist in this area. I know enough to pick sensible architectures, optimize queries, and maintain good indexes.
- amock 16y ago9.0 has asynchronous replication and 9.1 will have synchronous replication http://developer.postgresql.org/pgdocs/postgres/warm-standby.html#SYNCHRONOUS-REPLICATION http://developer.postgresql.org/pgdocs/postgres/warm-standby... .