Re: PostgreSQL Concern Regarding PITR.

From: Rui DeSousa <rui(at)crazybean(dot)net>
To: Vivek Gadge <vvkgadge56(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, vinod16895(at)gmail(dot)com
Subject: Re: PostgreSQL Concern Regarding PITR.
Date: 2020-06-07 16:27:57
Message-ID: EFF7D73E-D5EA-4561-9907-0F7A8302EC2A@crazybean.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jun 6, 2020, at 2:24 PM, Vivek Gadge <vvkgadge56(at)gmail(dot)com> wrote:
>
> Is it possible to perform the table level PITR in postgresql version 9.6 or 10, if yes could u plz assist .
>

Very common restore situation. To accomplish it; you need the ability to a restore and instantiate an out of band instance and then review/extract the data needed. This really should be part of your recovery plan as it is more likely to occur than a full database recovery. Your backup solution is going to dictate how this occurs.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message vinod kale 2020-06-09 01:57:15 block corruption message in error logs.
Previous Message Greg Spiegelberg 2020-06-07 12:38:24 Re: PostgreSQL Concern Regarding PITR.