Skip site navigation (1) Skip section navigation (2)

wal logs in pg_xlog

From: Nasir Iqbal Danish <nasir(at)amaana(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: wal logs in pg_xlog
Date: 2005-06-27 06:04:50
Message-ID: 42BF9702.5000402@amaana.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

pgsql-admin by date

Next:From: Enzo D'addarioDate: 2005-06-27 06:13:18
Subject: vacuum taking longer over time
Previous:From: Jeff FrostDate: 2005-06-26 18:52:00
Subject: Re: restoring wal archive and pg_xlog dir

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group