Hi,
Le lun. 21 mars 2022 à 15:07, Loles <lolesft(at)gmail(dot)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.