Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2D61E2E08D3 for ; Tue, 15 Jan 2008 12:32:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 76404-10 for ; Tue, 15 Jan 2008 12:32:29 -0400 (AST) Received: from smtp.l00-bugdead-prods.de (48.53.204.212.ediscom.de [212.204.53.48]) by postgresql.org (Postfix) with ESMTP id 4A7B22E023B for ; Tue, 15 Jan 2008 12:32:35 -0400 (AST) Received: by smtp.l00-bugdead-prods.de (Postfix, from userid 1001) id 0E8A93AAA1; Tue, 15 Jan 2008 17:32:32 +0100 (CET) organization: L00 bugdead prods. cc: pgsql-admin@postgresql.org X-Mailer: OpenGroupware.org MIME-Version: 1.0 from: "Sebastian Reitenbach" Subject: Re: backup WAL files, reply-to: "Sebastian Reitenbach" content-type: text/plain; charset="us-ascii" date: Tue, 15 Jan 2008 17:32:31 +0100 content-transfer-encoding: 7bit Message-Id: <20080115163232.0E8A93AAA1@smtp.l00-bugdead-prods.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/159 X-Sequence-Number: 27933 Hi, Tom Lane wrote: > "Sebastian Reitenbach" writes: > > The WAL files have names like this: > > 00000001000000010000003C > > > I am wonder what the meaning of the two 1 in the filename is? > > The first one (the first 8 hex digits actually) are the current > "timeline" number. The second one isn't very interesting, it's > an artifact of the way that WAL file locations are converted to > file names internally. thanks for this information. > > > Are the WAL > > file names counted up to FFFFFFFFFFFFFFFFFFFFFFFFF ? > > Then I'll run into problems anyways as these int number are too large to be > > handled by bash. > > You definitely should not expect to convert the names to integers. Then I do not understand why only the names of the first and the last WAL file are stored in the backup history file. I assumed that when I count from the first to the last I catch all WAL files needed for a complete backup. Then I have no idea how to figure out, which of the WAL files are needed for the backup job. Or do I have to handle this via the file modification timestamps? does anybody has a pointer to documentation where I can read up about how the names of the WAL files are created/used in postgres? thanks Sebastian