|
> Crashed how? Did the
*server* crash, or the database? I don’t know how it crashed yet, I’m
checking what the reason was. We will check if we have a recent backup. Yes, we made a compile file-system level copy of the
database. > There's no sign of corruption and an issue with
the clog doesn't imply data coruption, but you should still take a complete
copy before proceeding unless your backups are current and trusted. What does the issue with clog imply? We have 5 files in the clog folder:
> Please perform below steps: > 1. Backup the current pg_clog/0003 file in
different directory > 2. Create a file by assumption
of make the uncommitted record as they haven't been
committed. command as follows: > dd if=/dev/zero of=<data directory location>/pg_clog/0003
bs=256K count=1 > This is just a 256k zero-byte file. Here's one I
made earlier: I performed the procedure and the db started. How can
I check if it’s corrupted or not? > Create a file by assumption of make the uncommitted record as they haven't been committed. command as
follows: What does the file replacement actually did? Which
records is marked as uncommitted? Thanks a lot for your help |
