Re: XLogArchivingActive - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: XLogArchivingActive
Date
Msg-id 4475CC6A.9050900@pse-consulting.de
Whole thread Raw
In response to Re: XLogArchivingActive  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: XLogArchivingActive
Re: XLogArchivingActive
List pgsql-hackers
Tom Lane wrote:
> Andreas Pflug <pgadmin@pse-consulting.de> writes:
> 
>>I propose to introduce a GUC "permanent_archiving" or so, to select 
>>whether wal archiving happens permanently or only when a backup is in 
>>progress (i.e. between pg_start_backup and pg_stop_backup).
> 
> 
> This is silly.  Why not just turn archiving on and off?

Not quite. I want online backup, but no archiving. Currently, I have to 
edit postgresql.conf and SIGHUP to "turn on archiving" configuring a 
(hopefully) writable directory, do the backup, edit postgresql.conf and 
SIGHUP again. Not too convenient...

Regards,
Andreas


pgsql-hackers by date:

Previous
From: chelsea boot
Date:
Subject: Postgres Crashes on Win2K
Next
From: Jeremy Drake
Date:
Subject: psql \copy warning