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.
Questions tagged [pitr]
25 questions
18
votes
1 answer
Amazon DynamoDB via CloudFormation - point in time recovery
Is it possible to specify Point In Time Recovery for an Amazon DynamoDB table created via CloudFormation? I've been looking through the docs and user guide and haven't found anything useful yet.
ethrbunny
- 10,379
- 9
- 69
- 131
4
votes
1 answer
PostgreSQL PITR not working properly
I am trying to restore a PostgreSQL database to a point in time.
When I am using only restore_command in recovery.conf then its working fine.
restore_command = 'cp /var/lib/pgsql/pg_log_archive/%f %p'
When I am using the recovery_target_time…
YogeshR
- 1,606
- 2
- 22
- 43
3
votes
1 answer
PostgreSQL Point in time recovery not working
We have 2 PostgreSQL servers setup as master-slave.
I want to test below scenario
I took a base backup at master and then deleted a table and switched xlog file using command select pg_switch_xlog();. Then I stopped the master. Promoted slave as…
YogeshR
- 1,606
- 2
- 22
- 43
2
votes
2 answers
PostgreSQL restoration throwing error : replication slot does not exist
Environment: Postgresql 13.x (dockerized)
I was trying to test the DR setup for PostgreSQL nodes.
pg_basebackup and wal_files archive was taken from the standby mode.
Done restoration on a new node by copying pg_basebackup and configured…
Anto
- 3,128
- 1
- 20
- 20
2
votes
0 answers
Azure PostgreSQL Point In Time Restore not working
We have a Postgre database in Azure and we had a problem where all rows from a table where deleted.
We tried using the Point In Time Restore option in de azure portal but the database that is created has the same data as the currently running…
Jeroen van Heel
- 53
- 5
2
votes
2 answers
DynamoDB - restoring table using PITR for DynamoDB table managed by CloudFormation
I would like to be able to perform PITR restoration without losing benefit of Infrastructure-as-a-code with CloudFormation.
Specifically, if I perform PITR restoration manually and then point application to the new database, won't that result in…
Tofig Hasanov
- 3,303
- 10
- 51
- 81
2
votes
1 answer
PostgreSQL: point-in-time recovery for individual database and not whole cluster
As per standard Postgres documentation
As with the plain file-system-backup technique, this method can only support restoration of an entire database cluster, not a subset.
From this, I understood that it is not possible to setup PITR for…
user3792812
- 155
- 1
- 4
- 13
2
votes
1 answer
recovery.conf not getting changed to recovery.done after PITR
In recovery.conf, if we give recovery_target_time as 2018-09-07 03:25:46 (without EST) and restart PostgreSQL, recovery.conf is not getting changed to recovery.done.
Yet PITR is successful and records/tables are restored only till given time. But…
Amit
- 59
- 1
- 6
1
vote
1 answer
How to use Firebase Point-in-time recovery (PITR)?
I have just read the docs on the new Point-in-time recovery (PITR) release which I am absolutely pumped about.
I’m trying to test out the sample code provided by Firebase here for reading a PITR version and can’t get it to work. I have enabled PITR…
Brandon Dooley
- 21
- 4
1
vote
1 answer
How do I use MySQL Binlog for PITR
I am attempting to recover lost data using mysqlbinlog. Admittedly I am far from an expert in using MySQL, and even farther when using command line, so any advise would be very very welcome. I've seen so many docs that say what to do to view the…
ObbieWan
- 13
- 3
1
vote
2 answers
Azure SQL database point in time restore taking over 24 hrs
I have been trying to do a PITR of a 2GB S0 Azure SQL Server db. It has been running for over 24hrs. The DB restore progress has been saying 50% complete for 18
Hrs without any errors. Should I upgrade the server DTUs and size or the actual service…
1
vote
0 answers
How to estimate storage size for Azure SQL PiTR backups
How can I estimate how much storage will Point in Time Restore consume for a single instance of Azure SQL database? We want to switch from DTU to VCore model and I need to do some estimates for the management.
I am aware that this depends largely on…
Bojan Nedeljkovic
- 31
- 3
1
vote
0 answers
PITR using docker both master and slave
Can you please help on this. I have master and and slave both are dockerized. I already setup the master and it work fine:
@ inside of my master container
/var/lib/postgresql/9.3/main/postgresql.conf
archive_mode = on
archive_command = 'test ! -f…
jonathan
- 51
- 1
- 5
1
vote
1 answer
Why is pg_clog not mentioned in the postgresql document of Point-in-Time Recovery (PITR)?
Firstly, please forgive my poor English.
The key word, "pg_clog" is not mentioned in the chapter "Continuous Archiving and Point-in-Time Recovery (PITR)" of postgresql 9.x documents. But as I learned from the book, Database System Implementation,…
xuange
- 57
- 1
- 10
1
vote
1 answer
WAL Archive Backup and Restore
In a postgresql, how to create WAL archieve ?
Step by step explanation is available for Backup and Restore
using Linux or shell command?
Enviroment :
OS : LINUX RHEL 7.4
DB : Postgresql 9.2
is there any options without stopping postgresql complete…
Pramod Tiwari
- 298
- 5
- 16