3 ms·
Not that the database will get corrupted, but that's a good way to lose data.
by sp332 13y ago
Not that the database will get corrupted, but that's a good way to lose data.
- jeltz 13y agoA database should not lose any committed data on `kill -9` in the default configuration. This is why PostgreSQL waits on fsync on the write-ahead log before completing a commit. This can be disabled with synchronous_commit off, in which case you will indeed lose data on a crash.
- marcosdumay 13y agoNormaly, it's not nice to lose uncommited data.
- zAy0LfpBZLC8mAC 13y agoI said it already elsewhere in this thread, but either the writer has other persistent storage, then it should just keep the data and retry later and nothing will be lost, or the writer doesn't have other storage, then you will also lose uncommitted data with a normal shutdown, as you can not even try to commit any data while a data base is down.