Once, our developers had the bright idea of
deleting files to quickly purge data. Naturally, it corrupted everything, and points to the danger of developers having the postgres password...
On 7/16/19 7:07 AM, Holger Jakobs wrote:
Since your message says that the file is completely missing, someone must have deleted the file. There is nothing you can do except restoring from a backup.
Making sure postgres owns the files and the access rights are restricted to rw------- prevents this.
Even a file system error won't lead to this situation, as typically the file remains with length 0.
--
Angular momentum makes the world go 'round.