3 ms·

I look forward to when this lands on PostgreSQL 9.7 without the need for an extension. But more so when I can also include the Citus DB extension. Running Cit

I look forward to when this lands on PostgreSQL 9.7 without the need for an extension. But more so when I can also include the Citus DB extension. Running CitusDB with just 1 master made me nervous. They did talk about having multi-master replication as a belt and braces solution, but I don't know how far they got. Thinking about this. Both being used may give you a 100% fully fault tolerant solution?

atsaloli 10y ago
After 9.6, the next version will be 10.0. https://www.postgresql.org/message-id/flat/CABUevEzT3RqJZR2ioSePD7JQ_datTLNgS_v2GAwQMRWODc02jg%40mail.gmail.com#CABUevEzT3RqJZR2ioSePD7JQ_datTLNgS_v2GAwQMRWODc02jg@mail.gmail.com https://www.postgresql.org/message-id/flat/CABUevEzT3RqJZR2i...
tracker1 10y ago
Looking at the defects potential, I'm not sure I would rely on this as more than a "hotter spare" configuration... ex: only write to primary, then secondary if initial fails. Read from wherever. That said, It seems like this doesn't have the reliability constraints I'd really want to see... however as a "hotter" spare option, that might be nice. It seems like it wouldn't take much to turn this into a fast auto-failover master-slave model.