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.
:
Something is wrong and decide to recover.
:
5. Stop DB.
6. Remove new DB except the transaction files.
7. Copy back old DB.
8. And REDO. (But how?)
The tables or indexes are not created.
(At the begining of the system, all are created.)
Best regards,
