Re: what are the pg_clog and pg_xlog directories ?

 pg_xlog contains Postgres Write Ahead Logs (WAL, Postgres
implementation of transaction logging) files (normally 16MB in size,
each).
 pg_clog contains the commit log files which contain transaction commit
status of a transaction. One main purpose is to perform a database
recovery in case of a crash by replaying these logs.

----

    Husam
    http://firstdba.googlepages.com



-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Joao Miguel
Ferreira
Sent: Friday, May 05, 2006 5:31 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] what are the pg_clog and pg_xlog directories ?

Hello all,

can anyone tell me what are the 'pg_xlog' e 'pg_clog' directories in
/var/lib/pgsql/data ?

thanks

joao




---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may
containinformation that is legally privileged.  If you are not the addressee, or the person responsible for delivering
itto the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is
strictlyprohibited.  If you have received this message by mistake, please immediately notify us by replying to the
messageand delete the original message immediately thereafter. 

Thank you.

                                   FADLD Tag
**********************************************************************