From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
Cc: pgsql-performance@postgresql.org
Subject: Re: disable archiving
Date: Mon, 23 Jul 2007 19:39:10 +0200
Message-ID: <46A4E7BE.6090900@tweakers.net> (raw)
In-Reply-To: <1D073238-D174-4DD3-AD13-6B6F3E23A96B@sun.com>
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>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: acmmailing@tweakers.net, Paul.Vandenbogaard@Sun.COM
Subject: Re: disable archiving
In-Reply-To: <46A4E7BE.6090900@tweakers.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox