Deleting files isn't really faster than drop table. But it can easily lead to a corrupt database.
No developer should ever have the password of the operating system account postgres on a productive machine. Actually, not even any postgresql superuser password.
Am 16. Juli 2019 16:10:39 MESZ schrieb Ron <ronljohnsonjr@gmail.com>:
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.
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -