Обсуждение: How to check existing recovery points
Hi everyone!
There is any way to check them, other than looking in the log?
Can they be removed?
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?
Can they be removed?
Thanks!
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.
De : Loles <lolesft@gmail.com>
Envoyé : lundi 21 mars 2022 15:07
À : pgsql-admin@postgresql.org
Objet : How to check existing recovery points
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?
Can they be removed?
Thanks!
Hi
Unfortunately, there is no system catalog to show these points.
On the other hand, there is no way (and no need) to remove them.
Michel SALAIS