Re: Unable to connect DB...?

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(at)gmail(dot)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 -