Re: Unable to connect DB...?
| От | Holger Jakobs |
|---|---|
| Тема | Re: Unable to connect DB...? |
| Дата | |
| Msg-id | 8C73E826-AB26-463F-88AE-359279D6A38B@jakobs.com обсуждение исходный текст |
| Ответ на | Re: Unable to connect DB...? (Ron <ronljohnsonjr@gmail.com>) |
| Список | pgsql-admin |
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.
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
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 -
В списке pgsql-admin по дате отправления: