X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9538F5333F for ; Mon, 18 Apr 2005 19:00:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03656-08 for ; Mon, 18 Apr 2005 22:00:03 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [64.139.89.126]) by svr1.postgresql.org (Postfix) with ESMTP id 7B13B5331C for ; Mon, 18 Apr 2005 19:00:00 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id j3ILxvI25282; Mon, 18 Apr 2005 17:59:57 -0400 (EDT) From: Bruce Momjian Message-Id: <200504182159.j3ILxvI25282@candle.pha.pa.us> Subject: Re: Online backups and WAL In-Reply-To: <200504151204.57408.mcousin@sigma.fr> To: Marc Cousin Date: Mon, 18 Apr 2005 17:59:57 -0400 (EDT) Cc: pgsql-admin X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/249 X-Sequence-Number: 17262 Marc Cousin wrote: > Hi, > > I'm currently testing online backups, and I'm facing the problem of a missing > WAL when I do the backup : the current WAL isn't archived when I save the > archives, and is required to recover... > I've read in the mailing list archives that it can be solved by copying the > current WAL from pg_xlog. Even if this solution works, it looks to me to be > more of a workaround than anything else, and adds some complexity to an > operation that is allready not that simple. > I'd like to know if there is a way to force the switch from a WAL to the next > one, like with an 'alter system archive log current' in Oracle. No, there is no way to force a switch. It is on our TODO list as something to fix for 8.1. The development version of the docs make it much clearer: http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html This documentation update will be in 8.0.X. Sorry the system is currently confusing. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073