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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
