| From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, postgres hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Interaction of PITR backups and Bulk operationsavoiding WAL |
| Date: | 2007-03-09 17:06:47 |
| Message-ID: | 1173460007.9058.93.camel@coppola.muc.ecircle.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2007-03-09 at 17:47, Tom Lane wrote:
> I don't think that people are very likely to need to turn archiving on
> and off on-the-fly.
We did need occasionally to turn archiving on on-the-fly. It did happen
that I started up a new DB machine and I did not have yet the log
archive available, so I had to wait with configuring that, but the
machine went on-line before the archive machine was ready... and then
later I had to switch on archiving. It was very convenient that I could
do it without a restart.
It's true that has been rare occasion, more often you just need to
change the archive command (e.g. to archive to a different location if
the archive repository goes down).
It's somewhat moot for us as we changed to use Slony (which is a heavy
beast but once it works it's great).
Cheers,
Csaba.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaskiewicz | 2007-03-09 17:33:38 | Re: Estimating seq_page_fetch and random_page_fetch |
| Previous Message | Andreas Pflug | 2007-03-09 17:02:21 | Re: Interaction of PITR backups and Bulk operationsavoiding WAL |