Hi,
Le lun. 21 mars 2022 à 15:07, Loles <lolesft@xxxxxxxxx> 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.
