Date: Mon, 23 Feb 2026 14:07:47 -0800
From: dolan@directdemocracysolutions.com
To: pgsql-general@postgresql.org
Message-ID: <8386a590-62e4-4ce9-8c62-37dfa496f464@Spark>
Subject: Recovery Verification
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="699ccfbc_333ab105_84b9"
Archived-At: <https://www.postgresql.org/message-id/8386a590-62e4-4ce9-8c62-37dfa496f464%40Spark>
Precedence: bulk

--699ccfbc_333ab105_84b9
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi folks,

When performing database recovery tests, after restoring from backup is complete, what SOPs and tools do you use to sample your database contents and verify the data looks correct? Do you have a list of queries to run? What metadata do you capture and where do you save the test report? Do you use automation? Is it built in-house, off-the-shelf, or open-source?

Thanks, I'm not a DBA but no one else works at my company so any pointers would be appreciated.

-Dolan

--699ccfbc_333ab105_84b9
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<html xmlns=3D=22http://www.w3.org/1999/xhtml=22>
<head>
<title></title>
</head>
<body>
<div name=3D=22messageBodySection=22>
<div>Hi folks,</div>
<div>&=23160;</div>
<div>When performing database recovery tests, after restoring from backup=
 is complete, what SOPs and tools do you use to sample your database cont=
ents and verify the data looks correct=3F Do you have a list of queries t=
o run=3F What metadata do you capture and where do you save the test repo=
rt=3F Do you use automation=3F Is it built in-house, off-the-shelf, or op=
en-source=3F</div>
<div>&=23160;</div>
<div>Thanks, I'm not a DBA but no one else works at my company so any poi=
nters would be appreciated.</div>
<div>&=23160;</div>
<div>-Dolan</div>
</div>
</body>
</html>

--699ccfbc_333ab105_84b9--