Re: Verify or dump pgdata files
| От | Muhammad Ikram |
|---|---|
| Тема | Re: Verify or dump pgdata files |
| Дата | |
| Msg-id | CAJQ7xG4OLtxHZRqmnYH1pm9DYdtBXK_55DP5jarZFZSous+TNg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Verify or dump pgdata files (Murthy Nunna <mnunna@fnal.gov>) |
| Ответы |
RE: Verify or dump pgdata files
|
| Список | pgsql-admin |
Hi,
Could you use diff ? e.g.
diff -qr /var/lib/pgsql/15/data /tmp/data
Or
pg_checksums --verify --data-dir=/pgdata (for checksum enabled databases)
or do checksum on source and target and take diff between two checksum generated files e.g.
cd /pgdata
find . -type f -exec sha256sum {} \; > /tmp/source_checksums.txt
find . -type f -exec sha256sum {} \; > /tmp/source_checksums.txt
Regards,
Ikram
On Sun, Oct 20, 2024 at 4:45 AM Murthy Nunna <mnunna@fnal.gov> wrote:
Hi,
We are currently using pg_waldump to verify integrity of WAL files after archiving them in external storage. If the WAL is incomplete pg_waldump returns 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.
В списке pgsql-admin по дате отправления: