From: Murthy Nunna <mnunna@fnal.gov>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Verify or dump pgdata files
Thread-Topic: Verify or dump pgdata files
Thread-Index: Adsif/neNY7D4F5nTm+G67NZyIbinw==
Date: Sat, 19 Oct 2024 23:45:22 +0000
Message-ID: 
 <DM8PR09MB66778E385B20344549E6D3CDB8412@DM8PR09MB6677.namprd09.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?KqrdZqs8Ib6bPirJMDOgDNYdySUO1vVQWgXaYpRLqwGAe0ufZxv/s0yOZ/GP?=
 =?us-ascii?Q?lrq4wZUGbKix1mhU3xQPKdUhdrbT6u2CnT7ccM1gWPUOeDfI9ws4BJ7r7cEF?=
 =?us-ascii?Q?yKxVXD4bv9os2ko3EqQeItNyecU70UHidkBGD1/cGgtAfWM59r9JkmclJM/z?=
 =?us-ascii?Q?wvAKGT7F7b3pknm7J85fgNmtF+m0y5oSSKoXDftGngLlySZ4UnNVbvDZKIWn?=
 =?us-ascii?Q?dAHs+eXcezMCxwZFx+wwdK7+XSn5Bt+NfSBL6SbPOahJxi/S22zI5JgAmZfd?=
 =?us-ascii?Q?45yvD21RzZncUCEimkSPWl5Dmmkx0jxWxeLdqkoNTvpy9xPl0TLj2002IPz4?=
 =?us-ascii?Q?Pdnela3q0S4O/ivLjXP+ZorKnbCW4w91+jOF5vn3HpvNseH0a66Y4k3G8NVW?=
 =?us-ascii?Q?Jxjor3eoOA57L39qTUaosNsMCkyNGfRLL9byclX8mM+etiuugiFaSS+DBqh3?=
 =?us-ascii?Q?Oo0H10/sEn7rMep8uGAtboGJF+HmVVZM1nwUxL92mg4KvNcWDq/fjAZ56rm5?=
 =?us-ascii?Q?Y/IIIcjrnEAsaRllj3h5wMj0ZrPRw7tKgNvFBxNeSvtNCdS4GQVGXUgGiMbm?=
 =?us-ascii?Q?8ykcGnWwpdt2wF7drH8josS3hTrUSAz0EB3hpsopVPmXQSJSmLR/t7hu4c7q?=
 =?us-ascii?Q?QKB4rEh8rtZ+OIqToEvTOrqFT7MGXwxUoKcteu7PA6NED8+0USRnBFTy/yAI?=
 =?us-ascii?Q?6qfZ2OJXON+HqEGenemi6/5bPTBrNGLMT5N4bscMm7FHcFc3JuojQjXL9+G3?=
 =?us-ascii?Q?b7rlxybH3uWXvg7tw24xSXyEAb5Cli4Q8oj4X3feRsZ6WGGpYNTRGUZIc2xv?=
 =?us-ascii?Q?81VufoOkmQR//Mo3UeX8Iuv83Eb6HbohHHTPUbl64eFYMTZJMc9/aHWvPziy?=
 =?us-ascii?Q?bcX99EQB3XkW60tEL0ErVt2EtsBMcdjjpkKGyxcfzF3alJkJyBzIPrB/cSAE?=
 =?us-ascii?Q?paVx/QhArQ+7F7nJs5yBGYfgoSXHWZoe9CrwwEFX1pRCSv1iieodRueBsu0V?=
 =?us-ascii?Q?rcatFMmy7Dci/Se1fcJuf8kjniCULDmoTcK8Fidf05H6Y1tEBzD4Y9WwIN8H?=
 =?us-ascii?Q?XJjRRhL+QG8VrbOETiszYVpiBzm1BXhKf20jfxWcahN4HefE0Ml0v7jZsYbx?=
 =?us-ascii?Q?RwluoslKNE3jANC1hYWi+ybkI8dxz0jzZJHbYSZElBeLjwj10usiKqKLuYWf?=
 =?us-ascii?Q?WTeeQ/36jnm5Jjnu9zSwFb1pAFWhZzRGSRfL7z39nLRCxwZ+NKJbOxDYJaVr?=
 =?us-ascii?Q?z+HYRRaRtF2qEIImOmJ+0wzZ/08z6RthhooYiRIjOZdAGKzBgf1t+dLNuxGd?=
 =?us-ascii?Q?rkc1zsD9ouLveyy1g1b+nlUiMNtXAzvIQweKfB1uu8JVNZiSn/GcWnoWFTsx?=
 =?us-ascii?Q?rhGJV/nBTDG6eqzEIIe+zUkVAmaTXC4X4OScUFo2bpBOH50R+t9Zwr3U3QcE?=
 =?us-ascii?Q?/w/2fE8qWJvcm1LWvJcii5YDzPr910SV6tJXd0amEBrdqmL6rMCP/BMhJeog?=
 =?us-ascii?Q?MUyddBZB+S+rCral46Iiota46QbmWzl9KOIfY8VEbSj0iQc2H4TRsckyyqt1?=
 =?us-ascii?Q?pG4FbG3pcj+3RnT3jJrfj5ehjyNTFmZp+dOHM1fi?=
Content-Type: multipart/alternative;
	boundary="_000_DM8PR09MB66778E385B20344549E6D3CDB8412DM8PR09MB6677namp_"
MIME-Version: 1.0
X-OriginatorOrg: fnal.gov
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DM8PR09MB6677.namprd09.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 0e31c03c-628c-4485-ea52-08dcf09818ed
X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Oct 2024 23:45:22.3224
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH0PR09MB11471
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/DM8PR09MB66778E385B20344549E6D3CDB8412%40DM8PR09MB6677.namprd09.prod.outlook.com>
Precedence: bulk

--_000_DM8PR09MB66778E385B20344549E6D3CDB8412DM8PR09MB6677namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

We are currently using pg_waldump to verify integrity of WAL files after ar=
chiving them in external storage. If the WAL is incomplete pg_waldump retur=
ns error, which is great.

Similarly, I am wondering if there is any utility that can be used against =
data files in /pgdata. Just to verify after "rsync" of /pgdata.

Thanks in advance for your response.


--_000_DM8PR09MB66778E385B20344549E6D3CDB8412DM8PR09MB6677namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;
	font-weight:normal;
	font-style:normal;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Hi,<o:p></o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">We are currently us=
ing pg_waldump to verify integrity of WAL files after archiving them in ext=
ernal storage. If the WAL is incomplete pg_waldump returns error, which is =
great.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Similarly, I am won=
dering if there is any utility that can be used against data files in /pgda=
ta. Just to verify after &#8220;rsync&#8221; of /pgdata.<o:p></o:p></span><=
/p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Thanks in advance f=
or your response.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
</div>
</body>
</html>

--_000_DM8PR09MB66778E385B20344549E6D3CDB8412DM8PR09MB6677namp_--