About Redo
About Redo
От:
Osamu Ninagi <o.ninagi@asahi-net.email.ne.jp>
Дата:
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,
Re: About Redo
От:
Chris Ruprecht <chrup999@yahoo.com>
Дата:
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 Imaging). The scenario you are describing is sometimes called After Imaging and as far as I know, it is not (yet) implemented in PostgreSQL. Best regards, Chris At 02:51 +0900 02/14/2002, Osamu Ninagi wrote: >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. [snip] -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com