PostgreSQL Concern Regarding PITR.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

PostgreSQL Concern Regarding PITR.

Vivek Gadge
Is it possible to perform the table level PITR in postgresql version 9.6 or 10, if yes could u plz assist .

If no ,then is there any facilities/utilities provided in upgraded postgresql versions like 11 or 12 ?

Thanks & Regrads

Vivek Gadge.
Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL Concern Regarding PITR.

David G Johnston
On Saturday, June 6, 2020, Vivek Gadge <[hidden email]> wrote:
Is it possible to perform the table level PITR in postgresql version 9.6 or 10, if yes could u plz assist .

If no ,then is there any facilities/utilities provided in upgraded postgresql versions like 11 or 12 

No, WAL interleaves all data in the cluster, PITR simply stops WAL replay.  PITR will not produce a corrupted database cluster.  You have to PITR the whole thing then pull out the table from the restored version.

David J.

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL Concern Regarding PITR.

Greg Spiegelberg
In reply to this post by Vivek Gadge
On Sat, Jun 6, 2020, 10:51 PM Vivek Gadge <[hidden email]> wrote:
Is it possible to perform the table level PITR in postgresql version 9.6 or 10, if yes could u plz assist .

If no ,then is there any facilities/utilities provided in upgraded postgresql versions like 11 or 12 ?


For versions 11 and 12, look at the docs on logical replication,  publications and subscriptions.  Also search for change data capture (CDC) for examples on how to use. 

-Greg

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL Concern Regarding PITR.

Rui DeSousa
In reply to this post by Vivek Gadge


> On Jun 6, 2020, at 2:24 PM, Vivek Gadge <[hidden email]> 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.