Re: Duplicate history file?

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: Duplicate history file?
Дата
Msg-id 20210616.120722.2079142998904720856.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: Duplicate history file?  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
At Wed, 16 Jun 2021 12:04:03 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in 
> Ok, if we follow the direction that we are responsible for ensuring
> that every user has reliable backups, I don't come up with proper
> description about that.
> 
> We could list several "requirement" like "do sync after copy", "take a
> checksum for all files then check it periodically" or other things but
> what is more important things to list here, I think, is "how we run
> the archive_command".
> 
> Doesn't the following work for now?
> 
> (No example)
> 
> - "%f is replace by ... %p is .., %r is ... in archive_command"
> 
> - We call the archive_command for every wal segment which is finished.
> 
> - We may call the archive_command for the same file more than once.
> 
> - We may call the archive_command for different files with the same
>   name. In this case server is working incorrectly and need a
>   check. Don't overwrite with the new content.
> 
> - We don't offer any durability or integrity on the archived
>   files. All of them is up to you.  You can use some existing
>   solutions for archiving. See the following links.

Of course, there should be some descriptions about error handling
along with.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Duplicate history file?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: disfavoring unparameterized nested loops