Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to check existing recovery points

How to check existing recovery points

From
Loles
Date:
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

From
Guillaume Lelarge
Date:
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

From
"Michel SALAIS"
Date:

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