| From: | Alexander Cohen <alex(at)toomuchspace(dot)com> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: turn WAL off. |
| Date: | 2004-05-29 01:25:16 |
| Message-ID: | 0AADA570-B10F-11D8-9135-000A95B947DC@toomuchspace.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Fri, May 28, 2004 at 04:54:36PM -0400, Alexander Cohen wrote:
>> 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. It used to be possible before 7.1 right? At
least thats what it seems to say. It says something like "... since
7.1, WAL is turned on automatically..."
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-05-29 04:37:11 | Re: Use composite type for column data type |
| Previous Message | Doug McNaught | 2004-05-29 00:02:12 | Re: Dump 7.1.3->7.4.2 |