Subject: Re: Unable to connect DB...?
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJi6zqrKhy9AaO-4uXG3cH53Jst1jKfUQwnOQAh_5urb8Vwabw@mail.gmail.com>
 <1fd244fa-1e3c-4f02-01ee-03a1ffd25397@jakobs.com>
 <1f5b6b2b-4a1f-6456-dd21-871133b5d883@jakobs.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <52b61123-aa89-bf3b-6d0f-d6e89f14d9d2@gmail.com>
Date: Tue, 16 Jul 2019 09:10:39 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.7.2
MIME-Version: 1.0
In-Reply-To: <1f5b6b2b-4a1f-6456-dd21-871133b5d883@jakobs.com>
Content-Type: multipart/alternative;
 boundary="------------40BF1A7E56AA738366B137BC"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------40BF1A7E56AA738366B137BC
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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.

--------------40BF1A7E56AA738366B137BC
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Once, our developers had the bright idea of <b>deleting files</b>
    to quickly purge data.  Naturally, it corrupted everything, and
    points to the danger of developers having the postgres password...<br>
    <br>
    <div class="moz-cite-prefix">On 7/16/19 7:07 AM, Holger Jakobs
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:1f5b6b2b-4a1f-6456-dd21-871133b5d883@jakobs.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <p>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.</p>
      <p>Making sure postgres owns the files and the access rights are
        restricted to rw------- prevents this.</p>
      <p>Even a file system error won't lead to this situation, as
        typically the file remains with length 0.</p>
      <br>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------40BF1A7E56AA738366B137BC--