4 ms·

I'm wary of running anything with data I care about on a device without ECC RAM. From the docs: > PostgreSQL does not protect against correctable memory error

by jxcl 8y ago

I'm wary of running anything with data I care about on a device without ECC RAM. From the docs: > PostgreSQL does not protect against correctable memory errors and it is assumed you will operate using RAM that uses industry standard Error Correcting Codes (ECC) or better protection. https://www.postgresql.org/docs/11/wal-reliability.html https://www.postgresql.org/docs/11/wal-reliability.html Re: IS ECC RAM really needed? https://www.postgresql.org/message-id/20070526145214.GA21290@mark.mielke.cc https://www.postgresql.org/message-id/20070526145214.GA21290...

vkaku 8y ago
You'd be surprised to read about bitrot then. Well, storage is the one that causes maximum damage there, especially really old data.
- jxcl 8y ago
  That may also be a concern, but there are software workarounds. I would also not run Postgres on a non-checksummed filesystem or without data checksums enabled in the postgres cluster.
  - vkaku 8y ago
    Well, one also needs periodic scrubbing. Without that, it rots!
Phrodo_00 8y ago
There's a lot more to worry about in the Raspberry PI, starting with SD storage
Tepix 8y ago
Do you have a laptop with ECC RAM then?