tag:blogger.com,1999:blog-427258967255390991.post2761906669432276339..comments2024-03-01T16:24:46.081+08:00Comments on The Tech Faucet: Avoiding PostgreSQL database corruptionCraig Ringerhttp://www.blogger.com/profile/02343803844223399065noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-427258967255390991.post-68133359048492661622014-06-07T13:51:50.386+08:002014-06-07T13:51:50.386+08:00NFS with 'nointr,hard' connected to a soli...NFS with 'nointr,hard' connected to a solid, reliable NFS server can be OK, actually. In general, if it's horribly slow then it's probably working properly ;-)Craig Ringerhttps://www.blogger.com/profile/02343803844223399065noreply@blogger.comtag:blogger.com,1999:blog-427258967255390991.post-14740181301029385092013-05-28T18:05:13.975+08:002013-05-28T18:05:13.975+08:00I seem to recall that another great option for dat...I seem to recall that another great option for database corruption is to install it on network attached storage, such as a NAS or mounted on NFS or CIFS.<br /><br />Losing the link to such storage is quite possibly worse than losing an fsync. Networks don't have a BBU unit, for starters.<br /><br />Added bonus, such file systems don't support all the file-system flags, which in case of file locking flags allows multiple processes to garble up a file with no trouble whatsoever.Anonymoushttps://www.blogger.com/profile/02230872889527782665noreply@blogger.comtag:blogger.com,1999:blog-427258967255390991.post-66668922437130465712012-10-18T21:34:34.855+08:002012-10-18T21:34:34.855+08:00Best piece of Advice for a DB AdministratorBest piece of Advice for a DB AdministratorRamachandranhttps://www.blogger.com/profile/03648044388072904510noreply@blogger.comtag:blogger.com,1999:blog-427258967255390991.post-14862234283764179572012-10-18T01:35:13.968+08:002012-10-18T01:35:13.968+08:00Thats good advice!
Indeed, the postgresql manual i...Thats good advice!<br />Indeed, the postgresql manual is a great resource. On our team we are about to install a postgresql database with sync replication and the manual helped a lot for preparing and understanding. <br />I am not a db expert but Im happy to know that by reading the manual i understood a lot of the database inner workings and realized that most of your advices made a lot of sense, that we were communicating in the same language :)Polacohttps://www.blogger.com/profile/01143152507911164553noreply@blogger.com