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 199539FA322 for ; Wed, 21 Jun 2006 22:30:17 -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 15860-03 for ; Wed, 21 Jun 2006 22:30:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 3AF229FA3AF for ; Wed, 21 Jun 2006 22:30:07 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id k5M1U3G09804; Wed, 21 Jun 2006 21:30:03 -0400 (EDT) From: Bruce Momjian Message-Id: <200606220130.k5M1U3G09804@momjian.us> Subject: Re: archive_log command... In-Reply-To: <1150883232.5508.4.camel@localhost.localdomain> To: mario.splivalo@mobart.hr Date: Wed, 21 Jun 2006 21:30:03 -0400 (EDT) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL122 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/179 X-Sequence-Number: 22141 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. +