3 ms·
> a database that reliably preserves all of your customers' data when any one of your servers goes down (this unfortunately excludes many databases and makes th
by marcosdumay 6y ago
> a database that reliably preserves all of your customers' data when any one of your servers goes down (this unfortunately excludes many databases and makes the usual "just use Postgres" a poor choice, now flame me to high heaven)
You mean as in, backups have the latest data? Every transactional DB does that, postgres included. You just have to back-up the correct data (what is on the docs, for every one of them).
If you mean any DB server can go down at any time and the others must take over without losing any data, then your best bet is to hire a postgres expert to set it up for you. Both Oracle and SQL Server nominally do that, but they have flaws that their experts can't correct, and you won't be able to set any of them up without acquiring some expertise first.