pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feeddisable archiving
6+ messages / 5 participants
[nested] [flat]
* disable archiving
@ 2007-07-23 17:24 Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
0 siblings, 4 replies; 6+ messages in thread
From: Paul van den Bogaard @ 2007-07-23 17:24 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: disable archiving
@ 2007-07-23 17:34 Alvaro Herrera <alvherre@commandprompt.com>
parent: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
3 siblings, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2007-07-23 17:34 UTC (permalink / raw)
To: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>; +Cc: pgsql-performance
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.
Archiving is disabled by not setting archive_command.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: disable archiving
@ 2007-07-23 17:37 A. Kretschmer <andreas.kretschmer@schollglas.com>
parent: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
3 siblings, 0 replies; 6+ messages in thread
From: A. Kretschmer @ 2007-07-23 17:37 UTC (permalink / raw)
To: pgsql-performance
am Mon, dem 23.07.2007, um 19:24:48 +0200 mailte Paul van den Bogaard folgendes:
> the manual somewhere states "... if archiving is enabled..." To me
Please don't hijack other threads...
(don't edit a mail-subject to create a new thread. Create a NEW mail!)
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: disable archiving
@ 2007-07-23 17:39 Arjen van der Meijden <acmmailing@tweakers.net>
parent: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
3 siblings, 0 replies; 6+ messages in thread
From: Arjen van der Meijden @ 2007-07-23 17:39 UTC (permalink / raw)
To: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>; +Cc: 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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: disable archiving
@ 2007-07-23 17:42 Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 6+ messages in thread
From: Paul van den Bogaard @ 2007-07-23 17:42 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-performance
Alvaro,
thanks for the quick reply. Just to make sure: I do not set this
command. This results in the database cycling through a finite set
(hopefully small) set of WAL files. So old WAL files are reused once
the engine thinks this can be done.
Thanks
Paul
On 23-jul-2007, at 19:34, Alvaro Herrera wrote:
> 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.
>
> Archiving is disabled by not setting archive_command.
>
> --
> Alvaro Herrera http://
> www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
------------------------------------------------------------------------
---------------------
Paul van den Bogaard
Paul.vandenBogaard@sun.com
CIE -- Collaboration and ISV Engineering, Opensource Engineering group
Sun Microsystems, Inc phone: +31
334 515 918
Saturnus 1
extentsion: x (70)15918
3824 ME Amersfoort mobile: +31
651 913 354
The Netherlands
fax: +31 334 515 001
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: disable archiving
@ 2007-07-24 07:33 valgog <valgog@gmail.com>
parent: Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
3 siblings, 0 replies; 6+ messages in thread
From: valgog @ 2007-07-24 07:33 UTC (permalink / raw)
To: pgsql-performance
On Jul 23, 7:24 pm, Paul.Vandenboga...@Sun.COM (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 majord...@postgresql.org so that your
> message can get through to the mailing list cleanly
Is it normal to spoil other threads? or is it a bug?
If it is not a bug, please change the subject of the topic back to
what it was!
With best regards,
Valentine Gogichashvili
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-07-24 07:33 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-23 17:24 disable archiving Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
2007-07-23 17:34 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-07-23 17:42 ` Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>
2007-07-23 17:37 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2007-07-23 17:39 ` Arjen van der Meijden <acmmailing@tweakers.net>
2007-07-24 07:33 ` valgog <valgog@gmail.com>
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