Re: archive_log command... - Mailing list pgsql-admin

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. +