Skip to content

recovery-target-time do not support fractional second #109

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
gsmolk opened this issue Aug 6, 2019 · 1 comment
Open

recovery-target-time do not support fractional second #109

gsmolk opened this issue Aug 6, 2019 · 1 comment
Milestone

Comments

@gsmolk
Copy link
Contributor

gsmolk commented Aug 6, 2019

WAL records have timestamps with microsecond precision(6), so --recovery-target-time parameter must support them:

rmgr: Transaction len (rec/tot):     66/    66, tx:        554, lsn: 0/01840C40, prev 0/01840BA0, desc: COMMIT 2019-08-06 17:21:14.670041 MSK; inval msgs: snapshot 2396

I think we can just use https://github.com/thatguystone/approxidate
Our license is compatible with GPL

@gsmolk gsmolk modified the milestones: 2.2.0, 2.3.0 Sep 23, 2019
@gsmolk gsmolk modified the milestones: 2.3.0, 2.4.0 Feb 19, 2020
@gsmolk gsmolk modified the milestones: 2.4.0, 2.5.0 May 20, 2020
@gsmolk gsmolk modified the milestones: 2.5.0, 2.6.0 Jul 7, 2020
@sgrinko
Copy link

sgrinko commented Sep 1, 2021

Параметр восстановления: --recovery-target-time
на сейчас: pg_probackup-13 2.4.15
поддерживает указание с точностью только до секунд. А вот параметр самого postgres:
recovery_target_time поддерживает до микросекунд.
Я понимаю, что наверное не просто это реализовать, но очень хотелось бы иметь возможность передавать время восстановления с точностью до микросекунд.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants