Originally Posted by
xyzzy
I was expected to buy exotic database products from Larry Ellison, tended by smug contractors who had a million and one reasons Postgres just wouldn't do.
We've had a power outage on one of our test servers trash the Postgres database. But that was because the operating system truncated a bunch of files to zero bytes when it rebooted, so I doubt Oracle would have handled it any better.
That's the only system that doesn't have a battery-backed disk cache, which almost certainly would have prevented the problem.