Postgres Pro
Downloads
Home   >   mailing lists

Re: How to check existing recovery points - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: How to check existing recovery points
Date
Msg-id CAECtzeWp-1XdgoJpxQtD3oRzU4CoMAWxbh-JBr9w4h7z8YipVA@mail.gmail.com
Whole thread Raw
In response to How to check existing recovery points  (Loles <lolesft@gmail.com>)
List pgsql-admin
Tree view
Hi,

Le lun. 21 mars 2022 à 15:07, Loles <lolesft@gmail.com> a écrit :
Hi everyone!

I know how create news recovery points with pg_create_restore_point('name'); but I don't know but how to query the previously created points.

There is any way to check them, other than looking in the log?


You can always use pg_waldump. For example:

pg_waldump -r XLOG "some wal file" 2>&1  | grep "RESTORE_POINT"

(but replace "some wal file" with an actual WAL file name)

Can they be removed?


Nope.


--
Guillaume.

pgsql-admin by date:

Previous
From: Loles
Date:
Subject: How to check existing recovery points
Next
From: "Michel SALAIS"
Date:
Subject: RE: How to check existing recovery points