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 ) id 1t2xBu-008vXo-P6 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2024 18:31:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t2xBt-00AT9P-45 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2024 18:31:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t2xBs-00AT9C-N4 for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2024 18:31:41 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t2xBq-002GX4-7L for pgsql-admin@postgresql.org; Mon, 21 Oct 2024 18:31:40 +0000 Received: from phl-compute-09.internal (phl-compute-09.phl.internal [10.202.2.49]) by mailfout.stl.internal (Postfix) with ESMTP id 4AA0011400B2; Mon, 21 Oct 2024 14:31:36 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-09.internal (MEProxy); Mon, 21 Oct 2024 14:31:36 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1729535496; x= 1729621896; bh=FlpmqOgs+vfQtIQtEus+ef3KZs7dt8VmhjhrBxoZEuo=; b=X Cg5DF68QuoK7ebuz+TuipHYqxN5V1Vrf/nbw2E/DDLesuIxmcV/Yl0oyzExrh5T4 iNdmvQEuT7IRlM5jsMMitI7OkVtP9LH7d1jdxewAuZU1yWXZXDtX1ZZG4rmMKwy7 zNVnVf63wR45vuPN3t1LR+/k6BRlb24e2bphWeVYKyM8CSq0ug1LNQdKogWjBhOT 6LrsMUSiUMskPtgzYTROdIA2QLDEkR1WiAPaACJ3HfyY14eOBr3mvqkCZqqHdbm5 BZ9+gy2zecC+Fnprkkp1mhOfgO9qSZnIosQmvDC3kJTIRqtUuRGKTRdivnnNqk8e McIVvcx+a3toF98rNljPA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdehledguddviecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpeffhffvvefukfggtggugfgjsehtkeertddttdej necuhfhrohhmpeetlhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvh hhrdhnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpedvkedtffduffdtffffheff hfejjefhgfeiueeukeejkeffgfdufffhudffffeuveenucffohhmrghinhepvghnthgvrh hprhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehm rghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspg hrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepmhhnuhhnnhgr sehfnhgrlhdrghhovhdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehpohhsthhgrh gvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 21 Oct 2024 14:31:35 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1729535491; bh=BFoW0UVIS2pE3NX7KTr7j8fwl1jayjYK1ogtiR2eyh8=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=l8edQnKdAJWCe3GUihXW8JPXvZnMY9FtIhz8VE3HYEjlYKR8Plo8sNbRq1Jdi9/xL J7nHeWFL6GZg1mWjyi3Dh90B1ImdvNwELv+kwV2xjqfDlYPIbacg/LUD+e/f5s9VUw GyfVvht6nhLMu7vyjZkAjMTV/ifwfiFWRVUf9yGPz/IiF8InRQIablc4HtSSq+ZwFL gVlC1kWaeGT/94QY1EbsYhv4VzySnxLZfkRs3KRRFtZffZfjuqpJcETCD/hNAELxFG v1uYujPTCOaiJrunU8FxZyk41ksMbtII4zCAwnuvBai3VO5oEtNmOEX1cf0sk/VOO9 TbemGC2b76AgQ== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id EBED1E3; Mon, 21 Oct 2024 20:31:31 +0200 (CEST) Date: Mon, 21 Oct 2024 20:31:31 +0200 From: Alvaro Herrera To: Murthy Nunna Cc: "pgsql-admin@postgresql.org" Subject: Re: Verify or dump pgdata files Message-ID: <202410211831.tzcc3xjdnsn2@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-Oct-19, Murthy Nunna wrote: > 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. Maybe you could use pg_verifybackup for this, assuming you do your "rsync" with pg_basebackup. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/