| From: | Chris Ruprecht <chrup999(at)yahoo(dot)com> |
|---|---|
| To: | Osamu Ninagi <o(dot)ninagi(at)asahi-net(dot)email(dot)ne(dot)jp> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: About Redo |
| Date: | 2002-02-13 18:32:48 |
| Message-ID: | p05101201b89060fc3ca9@[192.168.0.6] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pam Wampler | 2002-02-13 19:00:07 | Is there a utility to load data? |
| Previous Message | Pam Wampler | 2002-02-13 18:10:56 | Can you turn off the WAL on importing data? |