X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7EBD39FA3CD for ; Tue, 27 Jun 2006 21:50:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 30714-02 for ; Tue, 27 Jun 2006 21:50:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id AB57F9FA5E7 for ; Tue, 27 Jun 2006 21:50:41 -0300 (ADT) Received: from [10.82.1.60] (docboy.decibel.org [65.86.67.34]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id B6BFC5644C; Tue, 27 Jun 2006 19:50:24 -0500 (CDT) In-Reply-To: <200606230542.k5N5gJG12667@momjian.us> References: <200606230542.k5N5gJG12667@momjian.us> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: mario.splivalo@mobart.hr, pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: archive_log command... Date: Tue, 27 Jun 2006 19:17:46 -0500 To: Bruce Momjian X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/268 X-Sequence-Number: 22230 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