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 CF9F652806 for ; Mon, 27 Jun 2005 11:56:44 -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 24311-10 for ; Mon, 27 Jun 2005 14:56:40 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 8623552980 for ; Mon, 27 Jun 2005 11:56:38 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j5REucVm083975 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 27 Jun 2005 08:56:41 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j5REucxA095472; Mon, 27 Jun 2005 08:56:38 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j5REuc30095471; Mon, 27 Jun 2005 08:56:38 -0600 (MDT) (envelope-from mfuhr) Date: Mon, 27 Jun 2005 08:56:38 -0600 From: Michael Fuhr To: Nasir Iqbal Danish Cc: pgsql-admin@postgresql.org Subject: Re: wal logs in pg_xlog Message-ID: <20050627145638.GB95400@winnie.fuhr.org> References: <20050625175849.GA18646@asu.edu> <28987.1119728982@sss.pgh.pa.us> <42BF9702.5000402@amaana.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <42BF9702.5000402@amaana.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/235 X-Sequence-Number: 17990 On Mon, Jun 27, 2005 at 11:04:50AM +0500, Nasir Iqbal Danish wrote: > > I am using postgres 8.0.3, and wanted to use Point In Time Recovery enable. > could any one tell me about how to indentify the current WAL file, also > let me know if there is any fix patteren for WAL log file generations. > documentaion says it will generate ever increasing number starting from > some thing like "0000000100000000000000000". but I have observed > different behaviour. What behavior have you observed? -- Michael Fuhr http://www.fuhr.org/~mfuhr/