Re: disable archiving

From: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
To: Paul van den Bogaard <Paul(dot)Vandenbogaard(at)Sun(dot)COM>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: disable archiving
Date: 2007-07-23 17:39:10
Message-ID: 46A4E7BE.6090900@tweakers.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Paul van den Bogaard 2007-07-23 17:42:06 Re: disable archiving
Previous Message A. Kretschmer 2007-07-23 17:37:49 Re: disable archiving