Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Why favor PostgreSQL over MariaDB/MySQL?. Parent comment
Use ZFS.
> removing a file on the filesystem may lead to a silent loss of data in PostgreSQL
Don't remove database files. LOL. Looking at the link:
> data file is zeroed after some power loss(it is the most known issue on XFS in the past)
> not even protected by checksums
There are no comments on this comment yet.
Use ZFS.
> removing a file on the filesystem may lead to a silent loss of data in PostgreSQL
Don't remove database files. LOL. Looking at the link:
> data file is zeroed after some power loss(it is the most known issue on XFS in the past)
Use ZFS.
> not even protected by checksums
Use ZFS.