Re: [ADMIN] About Redo

2002-02-13 Thread Chris Ruprecht
No. The WAL files do not contain data to redo everything which was done to the database since day X. The WAL files contain data of current active transactions. In case the transaction aborts, the database will be returned to the stage it was in before the transaction started (aka Before Imagin

[ADMIN] About Redo

2002-02-13 Thread Osamu Ninagi
Hello, I want to know the use of the transaction files in "pg_xlog". My concern is REDO such as ORACLE do. The following is our recovery method. I don't know whether it's possible or not. 1. Stop DB. 2. Clear the transaction files. 3. Save the directory "data" by tar command. 4. Start DB. : Somet