Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uSvCC-00Eqxz-Ja
	for pgsql-admin@arkaria.postgresql.org; Sat, 21 Jun 2025 10:11:36 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uSvC8-006ko9-L3
	for pgsql-admin@arkaria.postgresql.org; Sat, 21 Jun 2025 10:11:33 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <edwin.uy@gmail.com>)
	id 1uSvC8-006knx-4c
	for pgsql-admin@lists.postgresql.org; Sat, 21 Jun 2025 10:11:32 +0000
Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <edwin.uy@gmail.com>)
	id 1uSvC6-003DZQ-1e
	for pgsql-admin@lists.postgresql.org;
	Sat, 21 Jun 2025 10:11:31 +0000
Received: by mail-pj1-x102b.google.com with SMTP id
 98e67ed59e1d1-3137c20213cso2639067a91.3
        for <pgsql-admin@lists.postgresql.org>;
 Sat, 21 Jun 2025 03:11:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1750500688; x=1751105488;
 darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=WndKa0uNq5XiduXyDYktwN/Iwulif4ZNzmLnexSwL8o=;
        b=CboNeCPOQG5WdmZMWpm+HstJPI0DrBp/c/099HJivNTyttBL5pFQoV6FVOlorctdYX
         fiM7yAul2eGEUaYiVswgKUygFFi7fH/4jpRtGN2n5tofJtM+o5c7Xdy4Uk0moa3ePWzk
         6EkrUFG4fPQNLd+KWd7AJfJUK8Dqik3JglV+AgpV+D5NBqNrN+nzmPpv6mgWwYMetG6Q
         SZ35Al68CkkMBuD4ZT6GlVM2vDLyrdb7i9dk6IEHWSfq6hWj+8RV0DL4uIBsKJpJTiKz
         L2O0I2Bv/asJVXJh1dPD1cOc/Yl2GzbzifHDG33UUDEI/eZzqyI5XrPn4hqhiCaQo56E
         WWIg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1750500688; x=1751105488;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=WndKa0uNq5XiduXyDYktwN/Iwulif4ZNzmLnexSwL8o=;
        b=mcNi4rpqNyAoa15J0NO7J7TNmvw1n6gMGjGPJaC7WXUEO55s4jKrjvR3E4B8fvY++K
         /qHJ9LtQJu5RyH+K2hG2nJWL2NPNzaAVjcyBgv0E7xBEWlQOG8pDCSuXfthDkKcZoNDh
         Gi7b5cEFyarCBWYbN28VF7GlxB2hIlI+a1PoncDV6WbLduzoKG0/dQSKqJ/liB5x3RWw
         nTN5pR1eIV8afpuJzwKopVeVFaRhnrblKrXagBI3E1kd/iD+S4D+Elcm8hYokDbbzp60
         7VDg+CrQOBv9XVUDuxg48xsP8QAlGisdTBXaYYbu/qbAdbWvl9d7aHj8qSoijkeeUAHa
         9Mrw==
X-Gm-Message-State: AOJu0Yw9aEMarCJwF4Q1+eZ8A6D5WczQhnGHSF7uOFAce1LKOFIFQsxT
	ieGV93/rmW0tjmUy6z6li1uQy7AMSNOGjsuyoIyaO6uL/9MWmodKv/4qSdaxs84lrY6FgT5mVyi
	jU6CwOFevc14lHHM7pJtc93Kxn8OYJ4Hej8IgWGo=
X-Gm-Gg: ASbGncsRpukTumS2vnLFvQdc5j72MiL0EGlJaoehSfKBz8KjdM7TYUA+AsAOQ9923WH
	AsYzuVZgLZz42lQrmx6n94MqtghZj1VxtPg6y0vAsqNDSy+G9Tm3UsPoq8mMflRwJrQgUvpkJRn
	Vq7M/F+e9S32XyQhRFy8h1syjqn18U9ghQHagEq5anddk=
X-Google-Smtp-Source: 
 AGHT+IF1y9n8j0pv241Y3cYNsmdVu8Pc8onhPskOBpfWn2lE/SxrOziYy4di/jXdEVG9XXA37L1Oz5wBdzDJCxohIEo=
X-Received: by 2002:a17:90a:c883:b0:311:ab20:159a with SMTP id
 98e67ed59e1d1-3159d8d9098mr9421558a91.29.1750500688354; Sat, 21 Jun 2025
 03:11:28 -0700 (PDT)
MIME-Version: 1.0
From: Edwin UY <edwin.uy@gmail.com>
Date: Sat, 21 Jun 2025 22:10:52 +1200
X-Gm-Features: Ac12FXx9sqO9u7eWp8LmDd_Xh_7fkuOgpQlRAlAdQqDbWoFA90xlm4lesEUnPOU
Message-ID: 
 <CA+wokJ_Qz9DYU39G3ABD6Qu95LjCT3FboYE6aW3yzcxMxSRwnw@mail.gmail.com>
Subject: pg_restore Question
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b56482063812330f"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ_Qz9DYU39G3ABD6Qu95LjCT3FboYE6aW3yzcxMxSRwnw%40mail.gmail.com>
Precedence: bulk

--000000000000b56482063812330f
Content-Type: text/plain; charset="UTF-8"

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

--000000000000b56482063812330f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><span style=3D"font-family:monospace">Hi,</span></div=
><div><span style=3D"font-family:monospace"><br></span></div><div><span sty=
le=3D"font-family:monospace">Without access to the dumpfile or log file, is=
 there any way to check whether=C2=A0a database has been restore either by =
pg_restore or other means?</span></div><div><span style=3D"font-family:mono=
space"><br></span></div><div>Regards<span style=3D"font-family:monospace">,=
</span></div><div><span style=3D"font-family:monospace">Edd</span></div><di=
v><span style=3D"font-family:monospace"><br></span></div><div><span style=
=3D"font-family:monospace"><br></span></div></div>

--000000000000b56482063812330f--