Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWQeR-000457-0o for pgsql-admin@arkaria.postgresql.org; Mon, 21 Mar 2022 22:37:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWQeQ-00043l-0B for pgsql-admin@arkaria.postgresql.org; Mon, 21 Mar 2022 22:37:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWQeP-00043c-MR for pgsql-admin@lists.postgresql.org; Mon, 21 Mar 2022 22:37:21 +0000 Received: from mout.kundenserver.de ([212.227.17.24]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWQeN-0007cP-0j for pgsql-admin@postgresql.org; Mon, 21 Mar 2022 22:37:20 +0000 Received: from ANAT ([78.194.114.252]) by mrelayeu.kundenserver.de (mreue107 [212.227.15.184]) with ESMTPSA (Nemesis) id 1MEmpp-1nHnGR0bAx-00GF9K; Mon, 21 Mar 2022 23:37:16 +0100 From: "Michel SALAIS" To: "'Loles'" , References: In-Reply-To: Subject: RE: How to check existing recovery points Date: Mon, 21 Mar 2022 23:37:13 +0100 Message-ID: <00ed01d83d74$36d6d820$a4848860$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00EE_01D83D7C.989CEDD0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQJ4QhqS4E9TgGFYefErjGTZj9mcRKuKYsGw Content-Language: fr X-Provags-ID: V03:K1:AVWxTDzfvAqAaT0Sb4nNHyooFIGtfi3vdNT6hi1V3i52nVDUJ3L pr5CE2dLYDZFsazdzj1YEJQ26EJ67s2c1nN4VKzklk34XP57hVIrtzdg65O9W9mzHJ25uVH 9ck6Z3ohYZHjfM/XY06LdAo4sUgySX1k/6tG2p8LX0VOWlJ6zxwc1Oowhv9NzlEwQ3/duHK 7s8RrYvcUOg4yRkTU/oWA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:89W3RlxRFLA=:6p0HXmmIiXJPw3v9VkriFE it+6U+Bbwr+ut8xIoCH+MJCqni52csuUaXmbHvKqaGELLp0T7KL5X7h19Boow+2It8YoDBnWj OlPNmo6zJcF/8N0dnbNg2ZglB9cAHb6SsOBrqS8cqmnIpYKlsrcMmivACw8tDb7wbTZQEKHc+ FGc1D17JjLyDaeY0550J/E0A7CXn4Opv+nY69Rozrcr2j9joZiur0MUBm7LOkH9yYXrNdlqyS yL1RRApFjA0SksoRwal/coA0JBBvPAaqURWmejN5PRwEZqdKuzw7LHCOREARXHABlsmRi0HuP 2G/jmXLS1uAEBr4TYS47r+qmSOhlgEpv1UhMemmA60sYn6Sdb3AZPjMcok4ejDLX0OU6/xt1C MazkNvMJT75xBHqnU57Ya4SkVgaRuw1076eL7FnKVA6t8DE+1+1zi/i1r8e3jKQ7ss8lFc4ZR wV3ot/VPUeNEMhWH1uxoocO3xSAEkiXiydY+6a45oiwWCfYOak7sDQhhZthlYACm2GYGlKP9q 8a4kWzrTLsew5eord1vAt/Hijcv4RFqBZ1p1JT6LvoKCgj3E2xGn7+Od8AOULVt7dqLysvq9T xETjkZt7PT2XM5iuIsCqoqu6TOhkAl5IWrfhwV6fFH33nfKeZybMjuZY07bSpifj2AoObgNUC 6ajqVWJki87rOu1NYBtR+bIrcRJ8pJwfua9sn4w5Qwv8goHLkqgzwTpSW5jcjrBiBqJc= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_00EE_01D83D7C.989CEDD0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable De : Loles =20 Envoy=C3=A9 : lundi 21 mars 2022 15:07 =C3=80 : pgsql-admin@postgresql.org Objet : How to check existing recovery points =20 Hi everyone! =20 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? =20 Thanks! Hi =20 Unfortunately, there is no system catalog to show these points. On the other hand, there is no way (and no need) to remove them. =20 Michel SALAIS ------=_NextPart_000_00EE_01D83D7C.989CEDD0 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

De : Loles = <lolesft@gmail.com>
Envoy=C3=A9 : lundi 21 mars = 2022 15:07
=C3=80 : = 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

------=_NextPart_000_00EE_01D83D7C.989CEDD0--