pgmoneta / pgmoneta

Backup / restore solution for PostgreSQL
https://pgmoneta.github.io
BSD 3-Clause "New" or "Revised" License
154 stars 42 forks source link

Client Side Timeline/Backup LSN Support #187

Closed Jubilee101 closed 8 months ago

Jubilee101 commented 9 months ago

Currently pgmoneta has little support for fetching/extracting LSN info related to timeline and backup. We would like the following feature:

Some references: https://www.highgo.ca/2021/11/01/the-postgresql-timeline-concept/ https://developer.aliyun.com/article/234 https://www.postgresql.org/docs/current/protocol-replication.html

Jubilee101 commented 8 months ago

Close this as most tasks have been done. I'll later submit a separate issue for server side LSN. That'll tie into the extension project, and require looking into postgres internals - base backup command as well as mvcc stuff.