Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1r5ksU-00ErrH-Lh
	for pgsql-general@arkaria.postgresql.org; Wed, 22 Nov 2023 10:54:43 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1r5ksT-007jwO-70
	for pgsql-general@arkaria.postgresql.org; Wed, 22 Nov 2023 10:54:41 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1r5ksS-007jwG-LE
	for pgsql-general@lists.postgresql.org; Wed, 22 Nov 2023 10:54:40 +0000
Received: from ssl.schlittermann.de ([46.38.236.101])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1r5ksL-007lXn-Dh
	for pgsql-general@lists.postgresql.org; Wed, 22 Nov 2023 10:54:40 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=schlittermann.de; s=dd201504; h=Content-Transfer-Encoding:Content-Type:
	In-Reply-To:From:References:To:Subject:MIME-Version:Date:Message-ID:Cc:
	Content-Description:Content-ID:Resent-Cc:Resent-To;
	bh=LXAajX6q4dtxHP+BONNpPZtsC7ZKcKARyDVVbYHB22s=; b=aeZtUrD0fzRKnURcS0qT08F/Nu
	EKy5vy2hPDvcEdTFGEiJ+ANnjQNPSnhDdlD46T2+8pNM1AS0npDgocvenItx5MP3dewZbtjfmUL9R
	dT92RfJXD1iWGLW3JurRYHmZFHr2csDxIu7okWiF/gDq3WH9ZxkNXaHI3JtSjwUJ9FWg=;
Received: by ssl.schlittermann.de with esmtpsa
 (TLS1.3:TLS_AES_128_GCM_SHA256:128)
	(Exim 4.x)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1r5ksK-00Et9G-31
	for pgsql-general@lists.postgresql.org;
	Wed, 22 Nov 2023 11:54:32 +0100
Message-ID: <ff17e565-e1bd-ed59-33f8-001a3ff97c26@a-kretschmer.de>
Date: Wed, 22 Nov 2023 11:54:21 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: PITR
Content-Language: en-US
To: pgsql-general@lists.postgresql.org
References: 
 <CAJk5Atb_8Rmr8DmxWFmtR44CRQrT9cc4Nso9Z85owT3E-=OQ0w@mail.gmail.com>
 <CANzqJaDq4eUikUxAsj6WVyNrxwi94wJ2buW-_RcM=eoS6XmXsQ@mail.gmail.com>
From: Andreas Kretschmer <andreas@a-kretschmer.de>
In-Reply-To: 
 <CANzqJaDq4eUikUxAsj6WVyNrxwi94wJ2buW-_RcM=eoS6XmXsQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/ff17e565-e1bd-ed59-33f8-001a3ff97c26%40a-kretschmer.de>
Precedence: bulk



Am 22.11.23 um 11:50 schrieb Ron Johnson:
> On Wed, Nov 22, 2023 at 3:12 AM Rajesh Kumar 
> <rajeshkumar.dba09@gmail.com> wrote:
>
>
>
>     How do I do PITR. Backup strategy is weekly full backup and daily
>     differential backup. Using pgbackrest.
>
>     Also. In future how do i monitor time of drop commands.
>

https://blog.hagander.net/locating-the-recovery-point-just-before-a-dropped-table-230/


Andreas

-- 
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com