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
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