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 2888652985 for ; Mon, 27 Jun 2005 03:04:30 -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 24471-05 for ; Mon, 27 Jun 2005 06:04:24 +0000 (GMT) Received: from localhost.localdomain (unknown [202.142.164.58]) by svr1.postgresql.org (Postfix) with ESMTP id CCDFA5292F for ; Mon, 27 Jun 2005 03:04:19 -0300 (ADT) Received: from [192.168.254.11] (nasir [192.168.254.11]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id j5R6471a004814 for ; Mon, 27 Jun 2005 11:04:08 +0500 Message-ID: <42BF9702.5000402@amaana.com> Date: Mon, 27 Jun 2005 11:04:50 +0500 From: Nasir Iqbal Danish User-Agent: Mozilla Thunderbird 0.8 (X11/20041020) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: wal logs in pg_xlog References: <20050625175849.GA18646@asu.edu> <28987.1119728982@sss.pgh.pa.us> In-Reply-To: <28987.1119728982@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/224 X-Sequence-Number: 17979 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. I would also want to know, how does it archive files. for example we have log file 000002, now when archiving will it start new file as 000003 or will it archive 000002 as 000003 and lastest will be same as 000002. - Nasir