data_sync_retry is a configuration parameter determining whether PostgreSQL should issue a
PANIC on failure to flush modified data files to the file system.
The default value for
By default, a
PANIC-level error message will be emitted if it is unable to flush modified data files to the file system. This will result in a PostgreSQL server crash.
data_sync_retry is set to
on, there is a risk of data loss because on some operating systems, dirty data cached by the kernel may have been dropped on
write-back failure. A subsequent call to
fsync() may appear to succeed, but not have flushed the data, meaning that a future checkpoint could apparently complete successfully but without actually writing data to disk.
Normally there is no reason to set