Message-ID: <46A4E7BE.6090900@tweakers.net>
Date: Mon, 23 Jul 2007 19:39:10 +0200
From: Arjen van der Meijden <acmmailing@tweakers.net>
User-Agent: Thunderbird 2.0.0.5 (Windows/20070716)
MIME-Version: 1.0
To: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
CC: pgsql-performance@postgresql.org
Subject: Re: disable archiving
References: <1185209223.224236.163350@57g2000hsv.googlegroups.com>
	<28463.1185210040@sss.pgh.pa.us>
	<1185210796.731691.206490@g4g2000hsf.googlegroups.com>
	<1D073238-D174-4DD3-AD13-6B6F3E23A96B@sun.com>
In-Reply-To: <1D073238-D174-4DD3-AD13-6B6F3E23A96B@sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Perhaps you should've read the configuration-manual-page more carefully. ;)
Besides, WAL-archiving is turned off by default, so if you see them 
being archived you actually enabled it earlier

The "archive_command" is empty by default: "If this is an empty string 
(the default), WAL archiving is disabled."

http://www.postgresql.org/docs/8.2/interactive/runtime-config-wal.html

Best regards,

Arjen

On 23-7-2007 19:24 Paul van den Bogaard wrote:
> the manual somewhere states "... if archiving is enabled..." To me this 
> implies that archiving can be disabled. However I cannot find the 
> parameter to use to get this result. Or should I enable archiving and 
> use a backup script like
> 
> #!/usr/bin/bash
> exit 0
> 
> 
> 
> Would appreciate a hint. And yes I know I put my database in danger etc. 
> This is for some benchmarks where I do not want the overhead of 
> archiving. Jus a file system that will not fill with zillions of these 
> 16MB WAL files ;^)
> 
> Thanks
> Paul.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>