dalibo / pitrery

DEPRECATED. PostgreSQL Point In Time Recovery made easy
http://dalibo.github.io/pitrery/
Other
108 stars 31 forks source link

Add Timeline & WAL location or checkpoint from pg_controldata in output and list #159

Open Krysztophe opened 3 years ago

Krysztophe commented 3 years ago

I'd like to have some information about the timeline and the WAL location, more or less what comes pg_controldata provides:

Latest checkpoint location:           1F/BE000060
Latest checkpoint's REDO location:    1F/BE000028
Latest checkpoint's REDO WAL file:    000000020000001F000000BE
Latest checkpoint's TimeLineID:       2

That would appear in the backup , list and restore.

I'm trying to understand why a restore does not work, and that would help to distinguish between the different available backups. That would useful when dealing with a mess of timelines.