Content-Type: multipart/alternative;
 boundary="------------rgmyKFhyRYkPigvXVojz8mJu"
Message-ID: <bce7a551-a1e1-4777-b476-abc61126e3b3@netcologne.de>
Date: Sun, 22 Jun 2025 11:55:06 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pg_restore Question
To: pgsql-admin@lists.postgresql.org
References: 
 <CA+wokJ_Qz9DYU39G3ABD6Qu95LjCT3FboYE6aW3yzcxMxSRwnw@mail.gmail.com>
Content-Language: en-US
From: vrms <vrms@netcologne.de>
In-Reply-To: 
 <CA+wokJ_Qz9DYU39G3ABD6Qu95LjCT3FboYE6aW3yzcxMxSRwnw@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/bce7a551-a1e1-4777-b476-abc61126e3b3%40netcologne.de>
Precedence: bulk

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


the bash history might give you an idea.
You could not find anything though whether you did a restore from within 
the psql console, but that has a history too.


On 21.06.25 12:10, Edwin UY wrote:
> Hi,
>
> Without access to the dumpfile or log file, is there any way to check 
> whether a database has been restore either by pg_restore or other means?
>
> Regards,
> Edd
>
>
--------------rgmyKFhyRYkPigvXVojz8mJu
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Helvetica, Arial, sans-serif"><br>
      the bash history might give you an idea.<br>
      You could not find anything though whether you did a restore from
      within the psql console, but that has a history too.<br>
      <br>
      <br>
    </font><br>
    <div class="moz-cite-prefix">On 21.06.25 12:10, Edwin UY wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+wokJ_Qz9DYU39G3ABD6Qu95LjCT3FboYE6aW3yzcxMxSRwnw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div><span style="font-family:monospace">Hi,</span></div>
        <div><span style="font-family:monospace"><br>
          </span></div>
        <div><span style="font-family:monospace">Without access to the
            dumpfile or log file, is there any way to check whether a
            database has been restore either by pg_restore or other
            means?</span></div>
        <div><span style="font-family:monospace"><br>
          </span></div>
        <div>Regards<span style="font-family:monospace">,</span></div>
        <div><span style="font-family:monospace">Edd</span></div>
        <div><span style="font-family:monospace"><br>
          </span></div>
        <div><span style="font-family:monospace"><br>
          </span></div>
      </div>
    </blockquote>
  </body>
</html>

--------------rgmyKFhyRYkPigvXVojz8mJu--