[proposal] recovery_target "latest"
От | Grigory Smolkin |
---|---|
Тема | [proposal] recovery_target "latest" |
Дата | |
Msg-id | a3f650f1-fb0f-c913-a000-a4671f12a013@postgrespro.ru обсуждение исходный текст |
Ответы |
Re: [proposal] recovery_target "latest"
|
Список | pgsql-hackers |
Hello, hackers! I`d like to propose a new argument for recovery_target parameter, which will stand to recovering until all available WAL segments are applied. Current PostgreSQL recovery default behavior(when no recovery target is provided) does exactly that, but there are several shortcomings: - without explicit recovery target standing for default behavior, recovery_target_action is not coming to action at the end of recovery - with PG12 changes, the life of all backup tools became very hard, because now recovery parameters can be set outside of single config file(recovery.conf), so it is impossible to ensure, that default recovery behavior, desired in some cases, will not be silently overwritten by some recovery parameter forgotten by user. Proposed path is very simple and solves the aforementioned problems by introducing new argument "latest" for recovery_target parameter. Old recovery behavior is still available if no recovery target is provided. I`m not sure, whether it should it be left as it is now, or not. Another open question is what to do with recovery_target_inclusive if recovery_target = "latest" is used. -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
Вложения
В списке pgsql-hackers по дате отправления: