pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to check existing recovery points
3+ messages / 3 participants
[nested] [flat]
* How to check existing recovery points
@ 2022-03-21 14:07 Loles <lolesft@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Loles @ 2022-03-21 14:07 UTC (permalink / raw)
To: pgsql-admin
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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to check existing recovery points
@ 2022-03-21 14:19 Guillaume Lelarge <guillaume@lelarge.info>
parent: Loles <lolesft@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Guillaume Lelarge @ 2022-03-21 14:19 UTC (permalink / raw)
To: Loles <lolesft@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: How to check existing recovery points
@ 2022-03-21 22:37 Michel SALAIS <msalais@msym.fr>
parent: Loles <lolesft@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Michel SALAIS @ 2022-03-21 22:37 UTC (permalink / raw)
To: 'Loles' <lolesft@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-03-21 22:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-03-21 14:07 How to check existing recovery points Loles <lolesft@gmail.com>
2022-03-21 14:19 ` Guillaume Lelarge <guillaume@lelarge.info>
2022-03-21 22:37 ` Michel SALAIS <msalais@msym.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox