pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nasir Iqbal Danish <nasir@amaana.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: wal logs in pg_xlog
Date: Tue, 28 Jun 2005 17:52:34 +0500
Message-ID: <42C14812.7060607@amaana.com> (raw)
In-Reply-To: <20050627145638.GB95400@winnie.fuhr.org>
References: <20050625175849.GA18646@asu.edu>
	<28987.1119728982@sss.pgh.pa.us>
	<42BF9702.5000402@amaana.com>
	<20050627145638.GB95400@winnie.fuhr.org>

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

view thread (4+ messages)  latest in thread

Message-ID: <42C14812.7060607@amaana.com>
Permalink:  ../42C14812.7060607@amaana.com/
Also on:    postgresql.org/message-id/42C14812.7060607@amaana.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: nasir@amaana.com, mike@fuhr.org
  Subject: Re: wal logs in pg_xlog
  In-Reply-To: <42C14812.7060607@amaana.com>
  References: <20050625175849.GA18646@asu.edu> <28987.1119728982@sss.pgh.pa.us> <42BF9702.5000402@amaana.com> <20050627145638.GB95400@winnie.fuhr.org> <42C14812.7060607@amaana.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox