Обсуждение: How to check existing recovery points

Поиск
Список
Период
Сортировка

How to check existing recovery points

От
Loles
Дата:
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!

Re: How to check existing recovery points

От
Guillaume Lelarge
Дата:
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.

RE: How to check existing recovery points

От
"Michel SALAIS"
Дата:

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