pgsql: Prevent the already-archived WAL file from being archived again.

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема pgsql: Prevent the already-archived WAL file from being archived again.
Дата
Msg-id E1XhCtS-0004FL-W8@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Prevent the already-archived WAL file from being archived again.

Previously the archive recovery always created .ready file for
the last WAL file of the old timeline at the end of recovery even when
it's restored from the archive and has .done file. That is, there was
the case where the WAL file had both .ready and .done files.
This caused the already-archived WAL file to be archived again.

This commit prevents the archive recovery from creating .ready file
for the last WAL file if it has .done file, in order to prevent it from
being archived again.

This bug was added when cascading replication feature was introduced,
i.e., the commit 5286105800c7d5902f98f32e11b209c471c0c69c.
So, back-patch to 9.2, where cascading replication was added.

Reviewed by Michael Paquier

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c7371c4a607872c4d799e0dac0c9367574067cdc

Modified Files
--------------
src/backend/access/transam/xlog.c |   16 +++++++++-------
1 file changed, 9 insertions(+), 7 deletions(-)


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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: pgsql: Prevent the already-archived WAL file from being archived again.
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: Add a function to get the authenticated user ID.