Re: Unable to connect DB...?

Holger Jakobs <holger@xxxxxxxxxx> · Tue, 16 Jul 2019 16:13:44 +0200

  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@xxxxxxxxx>:

    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 -