"Qingqing Zhou" <[EMAIL PROTECTED]> wrote > > "Tom Lane" <[EMAIL PROTECTED]> wrote >> >> What we should be seeing, and don't see, is an indication of a backup >> block attached to this WAL record. Furthermore, I don't see any >> indication of a backup block attached to *any* of the WAL records in >> Alex's printout. The only conclusion I can draw is that he had >> full_page_writes turned OFF, and as we have just realized that that >> setting is completely unsafe, that is the explanation for his failure. >> >
According to Alex, seems the problem is not because of full_page_writes OFF > >> According to the discussion in pgsql-hackers, to finish this case, did >> you >> turn off the full_page_writes parameter? I hope the answer is "yes" ... >> > > If by off you mean full_page_writes = on then yes. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
