Problem with PITR recovery
От | Bruce Momjian |
---|---|
Тема | Problem with PITR recovery |
Дата | |
Msg-id | 200504160511.j3G5B6x29421@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: Problem with PITR recovery
|
Список | pgsql-hackers |
I had a problem using PITR recovery just now. If I do: SELECT pg_start_backup('label');do my tarSELECT pg_stop_backup(); and stop the server, delete /data, then recover from the tar, delete files in pg_xlog, then set recovery.conf to restore, it fails, I think because no actual pg_xlog file was archived since the tar. The problem is that we don't archive the partially written xlog file, and in this case that xlog file contains the information needed to make the tar file consistent. Is this a known problem? Do we document this? If so, I can't find it. I am concerned about folks cleaning out their archive directory after the pg_stop_backup() not realizing they need that last xlog file to make the tar valid. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
В списке pgsql-hackers по дате отправления: