About Redo

Поиск
Список
Период
Сортировка
От Osamu Ninagi
Тема About Redo
Дата
Msg-id 3C6AA7A9.2060509@asahi-net.email.ne.jp
обсуждение исходный текст
Ответы Re: About Redo  (Chris Ruprecht <chrup999@yahoo.com>)
Список pgsql-admin
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,



В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Number of connection
Следующее
От: Pam Wampler
Дата:
Сообщение: Can you turn off the WAL on importing data?