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 D8B58529F3 for ; Wed, 29 Jun 2005 06:56:27 -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 10093-02 for ; Wed, 29 Jun 2005 09:56:22 +0000 (GMT) Received: from localhost.localdomain (MAX-TNT-ISDN-20.nexlinx.net.pk [202.59.83.20]) by svr1.postgresql.org (Postfix) with ESMTP id 7E85052971 for ; Wed, 29 Jun 2005 06:56:10 -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 j5SCppck025485; Tue, 28 Jun 2005 17:52:19 +0500 Message-ID: <42C14812.7060607@amaana.com> Date: Tue, 28 Jun 2005 17:52:34 +0500 From: Nasir Iqbal Danish User-Agent: Mozilla Thunderbird 0.8 (X11/20041020) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Fuhr Cc: pgsql-admin@postgresql.org Subject: Re: wal logs in pg_xlog References: <20050625175849.GA18646@asu.edu> <28987.1119728982@sss.pgh.pa.us> <42BF9702.5000402@amaana.com> <20050627145638.GB95400@winnie.fuhr.org> In-Reply-To: <20050627145638.GB95400@winnie.fuhr.org> Content-Type: multipart/alternative; boundary="------------040208030203050704010204" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.392 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_20_30, HTML_MESSAGE, HTML_TITLE_EMPTY, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: ** X-Archive-Number: 200506/272 X-Sequence-Number: 18027 This is a multi-part message in MIME format. --------------040208030203050704010204 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Michael Fuhr wrote: >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? > > > the files in pg_xlog like 000010000000000005, 000010000000000006, 000010000000000007, 000010000000000008, (in short term call these 5,6,7,8). with file 8 being most recent and 5 being 2 months back, with respect to time stamp. after I did some work and then observed log files, now 5 and 6 were showing me latest time stamps. I was confused which is the latest one. I also want to know when new WAL segment files is created, is it 16MB or this will start from 0 bytes and size inceases as soon as db server will manupulate. Please provide me if u can some script to identify which one is latest file so that I can copy this to some other place. One more question. Is there a way to build or configure the database server to replicate pg_xlogs ? -Nasir --------------040208030203050704010204 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Michael Fuhr wrote:
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?

  
the files in pg_xlog like 000010000000000005, 000010000000000006, 000010000000000007, 000010000000000008, (in short term call these 5,6,7,8).
with file 8 being most recent and 5 being 2 months back, with respect to time stamp. after I did some work and then observed log files, now 5 and 6 were showing me latest time stamps. I was confused which is the latest one.
I also want to know when new WAL segment files is created, is it 16MB or this will start from 0 bytes and size inceases as soon as db server will manupulate.

Please provide me if u can some script to identify which one is latest file so that I can copy this to some other place.
One more question. Is there a way to build or configure the database server to replicate pg_xlogs ?
-Nasir
--------------040208030203050704010204--