|From:||Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru>|
|To:||Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>|
|Subject:||[proposal] recovery_target "latest"|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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.
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
|Next Message||Asif Rehman||2019-11-04 13:08:55||Re: WIP/PoC for parallel backup|
|Previous Message||Amit Kapila||2019-11-04 11:51:57||Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions|