pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
validating database integrity 2+ messages / 2 participants [nested] [flat]
* validating database integrity @ 2011-04-25 20:14 Scott Ribe <scott_ribe@elevated-dev.com> 0 siblings, 1 reply; 2+ messages in thread From: Scott Ribe @ 2011-04-25 20:14 UTC (permalink / raw) To: pgsql-admin Just had a hard crash, and pg came back looking ok. However, crash was in the driver for the (battery-backed) RAID card, and I know for a fact that one file that was written to the (journaled) file system before the crash was not there after reboot. So, what steps are recommended to make sure pg files are ok? Yeah, battery-backed cache does no good if the driver is crap... -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: validating database integrity @ 2011-04-27 08:38 lst_hoe02@kwsoft.de parent: Scott Ribe <scott_ribe@elevated-dev.com> 0 siblings, 0 replies; 2+ messages in thread From: lst_hoe02@kwsoft.de @ 2011-04-27 08:38 UTC (permalink / raw) To: pgsql-admin Zitat von Scott Ribe <scott_ribe@elevated-dev.com>: > Just had a hard crash, and pg came back looking ok. However, crash > was in the driver for the (battery-backed) RAID card, and I know for > a fact that one file that was written to the (journaled) file system > before the crash was not there after reboot. So, what steps are > recommended to make sure pg files are ok? I would say a full dump will let you know, at least for the data. > Yeah, battery-backed cache does no good if the driver is crap... Or the battery is leaking :-) Regards Andreas Attachments: smime.p7s (application/pkcs7-signature, 5.9K) download ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-04-27 08:38 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-04-25 20:14 validating database integrity Scott Ribe <scott_ribe@elevated-dev.com> 2011-04-27 08:38 ` lst_hoe02@kwsoft.de
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox