Stack Overflow
Stack Overflow

Questions tagged [pitr]

Point-in-Time Recovery Recovering database we could stop the replay at any point and have a consistent snapshot of the database as it was at that time. Thus, this technique supports point-in-time recovery: it is possible to restore the database to its state at any time since your base backup was taken.

25 questions
0
votes
1 answer

Using Supabase point-in-time recovery for undo redo

I'm creating an application in which users should be able to travel back in time on documents, and pick an older doc state to set as a new one. Kind of like a nice undo-redo functionality, with history all the way back to the start of the…
Sventies
  • 2,314
  • 1
  • 28
  • 44
0
votes
0 answers

How to do implement incremental backups in a PostgreSQL container

My requirement is to backup the data in PostgreSQL container, and considering the time-consuming issue, I plan to use WAL for incremental backup. I don't want to distinguish between primary and backup servers, I only have one server, and I want to…
Ckoala
  • 1
  • 1
0
votes
1 answer

Point-in-time restoration size VS Database data size

My question is very simple. I'm configuring Point-in-time Restore for an Azure SQL Database. Does the size of the storage data must be the same as the size of the database? i.e. If my storage data is 100GB, does my Point-in-time Restore need to be…
Daniel
  • 35
  • 4
0
votes
1 answer

Restoring a DynamoDB table using PITR and updating Cloudformation/CDK/other services references

I have an environment where my DynamoDB table is central to a few services (a couple of lambdas, kinesis and firehoses). All of that is managed by AWS's CloudFormation/Typescript CDK. This table has PITR enabled and, as far as I know, it's only…
Eduardo Elias Saléh
  • 806
  • 1
  • 11
  • 23
0
votes
0 answers

GCP Cloud SQL PITR, how long can it take?

We had sort of a disastrous event with a database at work (managed on Cloud SQL, it's a MySQL db) and thankfully we have point in time recovery enabled. We went ahead and cloned the production database to a certain point in time to be able to…
Weev
  • 36
  • 1
  • 8
0
votes
0 answers

How restore a cluster with tablespaces in postgresql windows 10

I created two tablespaces one for tables and the second for indexes. I use postgresql V 14.5 (win 10). With pg_basebackup of the cluster, I get 5 files : base.tar pg_wal.tar 21511.tar 21512.tar backup_manifest However, when I restore the…
ennine
  • 157
  • 5
0
votes
2 answers

Why is Postgres basebackup needed with WAL for PITR?

I'm reading the following article to setup PITR. One thing I'm confused about is why the article recommends performing a basebackup (full cluster backup) after setting up continuous WAL archiving. I thought WAL was the actual data? So if I have…
Digital Impermanence
  • 407
  • 1
  • 5
  • 16
0
votes
1 answer

Can not do PITR with specific time in PotgreSQL

I'm doing PITR with below settings and getting error as below. archive_command = 'test ! -f /usr/wal_archive/%f && cp %p /usr/wal_archive/%f' restore_command = 'cp /usr/wal_archive/%f "%p"' recovery_target_time = '2020-12-09…
Darshan Shah
  • 157
  • 1
  • 1
  • 15
0
votes
1 answer

Point-In-time-recovery in Greenplum Database

We have recently setup greenplum. Now the major concern is to setup strategy for PITR. Postgres provides PITR capability but I am a little confused as how will it work in greenplum as each segment will have it's own log directory and config file
makhshif afiniti
  • 55
  • 1
  • 8
0
votes
0 answers

How to manage postgreSQL 9.6 missing WAL segment from master server?

A have a PITR configuration with postgresql 9.6, with a master server, a intermediate server, and two slave servers, hot-standby but manually switched, such as this: Master | I1 / \ S1 S2 A failure writing to disk caused the master server to…
Aaron Rivacoba
  • 23
  • 4
1
2