On Oct 30, 2017 8:56 AM, "Josh Knapp" <[email protected]> wrote:
I'm not the biggest fan of PGSQL from the administration side. This probably stems from that I have not had a ton of experience messing with it except in very specific use cases. I have far more experience with MSSQL than postgres, but from everything I've read and the little I've tried, it's a serious database, much more focused on standards compliance. What tools are available if a table gets corrupted or messed up from an improper shutdown? Is it a case of purely restoring from backup? In general, any properly designed relational data store should protect you from truly "corrupt" data; any operations performed within a transaction should either all succeed our all fail. With that said, it's difficult for any software to deal with something as brutal as an improper shutdown--the kernel itself is no exception, and anything stored in a file has the possibility of being lost during an improper shutdown. The best you can hope for is that the software isolates the damage (through a journal, transaction log, etc.) so that one lost record doesn't take the rest of the system down with it.
_______________________________________________ Hpr mailing list [email protected] http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
