Обсуждение: archive_log command...
Can I force archiving of the WAL files using CHECKPOINT statement? My
checkpoing_segments is set to 32, but still archive_command is beeing
called up only every 45 minutes or so. Is there a way to speed this up a
bit? (I'd love to have it around 10 minutes, so I can have almost-live
backed-up server).
Mario
--
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
Mario Splivalo wrote: > Can I force archiving of the WAL files using CHECKPOINT statement? My > checkpoing_segments is set to 32, but still archive_command is beeing > called up only every 45 minutes or so. Is there a way to speed this up a > bit? (I'd love to have it around 10 minutes, so I can have almost-live > backed-up server). No, but it is on the TODO list. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote:
> Mario Splivalo wrote:
> > Can I force archiving of the WAL files using CHECKPOINT statement? My
> > checkpoing_segments is set to 32, but still archive_command is beeing
> > called up only every 45 minutes or so. Is there a way to speed this up a
> > bit? (I'd love to have it around 10 minutes, so I can have almost-live
> > backed-up server).
>
> No, but it is on the TODO list.
>
So, the only thing I could to is to reduce checkpoint_segments?
Mario
Mario Splivalo wrote: > On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote: > > Mario Splivalo wrote: > > > Can I force archiving of the WAL files using CHECKPOINT statement? My > > > checkpoing_segments is set to 32, but still archive_command is beeing > > > called up only every 45 minutes or so. Is there a way to speed this up a > > > bit? (I'd love to have it around 10 minutes, so I can have almost-live > > > backed-up server). > > > > No, but it is on the TODO list. > > > > So, the only thing I could to is to reduce checkpoint_segments? No, that doesn't help because a partially-filled WAL file with little database activity could be stay unarchived for a long time. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
On Jun 23, 2006, at 12:42 AM, Bruce Momjian wrote: > Mario Splivalo wrote: >> On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote: >>> Mario Splivalo wrote: >>>> Can I force archiving of the WAL files using CHECKPOINT >>>> statement? My >>>> checkpoing_segments is set to 32, but still archive_command is >>>> beeing >>>> called up only every 45 minutes or so. Is there a way to speed >>>> this up a >>>> bit? (I'd love to have it around 10 minutes, so I can have >>>> almost-live >>>> backed-up server). >>> >>> No, but it is on the TODO list. >>> >> >> So, the only thing I could to is to reduce checkpoint_segments? > > No, that doesn't help because a partially-filled WAL file with little > database activity could be stay unarchived for a long time. You can however copy the active WAL file at any time, and as many times as you want. And there's recently been a function added that will tell you what that exact file is (I think it's only in HEAD, but I could be wrong). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461