Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BA4042E2E77 for ; Wed, 16 Jan 2008 03:45:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 70463-01-7 for ; Wed, 16 Jan 2008 03:45:08 -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 70BC12E2E67 for ; Wed, 16 Jan 2008 03:45:05 -0400 (AST) Received: by smtp.l00-bugdead-prods.de (Postfix, from userid 1001) id E077A3AEB1; Wed, 16 Jan 2008 08:45:03 +0100 (CET) organization: L00 bugdead prods. X-Mailer: OpenGroupware.org MIME-Version: 1.0 from: "Sebastian Reitenbach" Subject: Re: backup WAL files, to: pgsql-admin@postgresql.org reply-to: "Sebastian Reitenbach" content-type: text/plain; charset="us-ascii" date: Wed, 16 Jan 2008 08:45:03 +0100 content-transfer-encoding: 7bit Message-Id: <20080116074503.E077A3AEB1@smtp.l00-bugdead-prods.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/176 X-Sequence-Number: 27950 Tom Lane wrote: > Tom Davies writes: > > On 16/01/2008, at 2:41 AM, Tom Lane wrote: > >> You definitely should not expect to convert the names to integers. > > > Presumably you can convert them to 96 bit integers? i.e. they are > > always strings of hex characters? > > You could, but in most scripting languages I can think of, it'd be > a lot easier just to treat them as strings. yeah, I tried to convert the whole filename into an integer, and then compare it, but the int was too large then, therefore I only took the last 9 hex digits and converted these. Anybody knows in which source file the filename is generated, then I can take a look by myself and get all the details how it is done? thanks for your insights Sebastian