Re: [patch] pg_copy - a command for reliable WAL archiving

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [patch] pg_copy - a command for reliable WAL archiving
Дата
Msg-id 9368.1408544373@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [patch] pg_copy - a command for reliable WAL archiving  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: [patch] pg_copy - a command for reliable WAL archiving  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-08-20 09:50:56 -0400, Alvaro Herrera wrote:
>> Andres Freund wrote:
>>> Isn't this a solution looking for a problem? We're using tempfiles in
>>> dozens of other places and I really don't see why this is the place to
>>> stop doing so. Just copy to <dest>.tmp and move it into place.

>> The issue is what happens if there's a crash while the temp file is in
>> the middle of being filled.

> The archive command will be be run again a couple seconds and remove the
> half-filled temp file.

Alternatively, you could use the process PID as part of the temp file
name; which is probably a good idea anyway.
        regards, tom lane



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: pg_basebackup vs. Windows and tablespaces
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [patch] pg_copy - a command for reliable WAL archiving