Re: disable archiving

Поиск
Список
Период
Сортировка
От Arjen van der Meijden
Тема Re: disable archiving
Дата
Msg-id 46A4E7BE.6090900@tweakers.net
обсуждение исходный текст
Ответ на disable archiving  (Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>)
Список 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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

В списке pgsql-performance по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: disable archiving
Следующее
От: Paul van den Bogaard
Дата:
Сообщение: Re: disable archiving