Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

How to see last possible backup (restore) time of wal archive #467

Copy link
Copy link
Open
@yennor

Description

@yennor
Issue body actions

I want to find out when the last successfull wal archive backup was made (being pushed by archive-push from db server), and what the last (newest) possible restore time would be. To centrally control that backups are being made correctly.
pg_probackup-11 show -B /var/lib/pg-probackup-11/ --archive
Doesn't seem to show that, neither does
pg_probackup-11 show -B /var/lib/pg-probackup-11/
This one only shows the timestamp of when the full/incremental/page backup was made.

I could just verify the date of the last .wal archive in the wal directory (and hope it was copied completely, and all the previous one were also copied completely).
But it would be easier if one of the commands would return that. So I can send warning messages in case there wasn't a successful wal archive backup in x hours/days/... .

Also it would make it easier to manually control when the last wal file was copied.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.