Alexander Cohen <alex@toomuchspace.com> writes: >>> Is it possible to turn WAL completely off. For good reasons, i dont >>> ever want to use it. How can i turn it off? >> >> You can't. The postgresql team is not in the business of producing >> databases that can't handle a power failure. >> >> Any hints as to what your "good reason" is? > I need a small cluster. Thats the main reason. 30 Mb with no data in it . > is pretty large, to me at least. And im not using it in a manner that a > power failure will matter. To be blunt, you don't want Postgres. Consider Berkeley DB or tinysql or (holds nose) MySQL. What you're after isn't within the design goals for this project, either as to disk footprint or disinterest in power failure behavior. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
