Questions tagged [point-in-time]
27 questions
5
votes
3 answers
How do I do backup and (point-in-time) recovery for etcd?
I understand that etcd stores its data in some kind of distributed log.
Are there tools to back up these logs and do recovery from them? Does that also support point-in-time recovery (and how far back can we go)?
Extra points: do these logs also…
Thilo
- 257,207
- 101
- 511
- 656
4
votes
1 answer
Is it possible to drop all database changes past a certain point in time?
I am trying to put together a means for resetting a (large, populated) postgreSQL database to a known state between integration tests.
I've been reading up on postgres's database recovery features, and it looks like it's possible to restore to a…
Mar
- 7,765
- 9
- 48
- 82
2
votes
1 answer
Snowflake Query for Latest Snapshot From Bitemporal Data
Given a table of data with bitemporal modeling where there are 2 dates: (i) the date that the data applies to, and (ii) the datetime at which the fact is known
City Temp Date As_of_Datetime
——— ———- ———- -——————-
Boston 32 …
Ramón J Romero y Vigil
- 17,373
- 7
- 77
- 125
2
votes
2 answers
Elasticsearch node js point in time search_phase_execution_exception
const body = {
query: {
geo_shape: {
geometry: {
relation: 'within',
shape: {
type: 'polygon',
coordinates: [$polygon],
},
},
},
},
pit: {
id: …
Андрей Ройзин
- 41
- 3
2
votes
1 answer
How can I create table with PITR enabled through API?
How can I create a dynamo db table with PITR enabled through API in java??
This is my create table request
CreateTableRequest createTableRequest = new CreateTableRequest()
.withTableName(properties.get(TABLE_NAME).textValue())
…
swarnim gupta
- 213
- 1
- 5
2
votes
1 answer
Efficient point-in-time query of group membership
We have a scenario like this:
Millions of records (Record 1, Record 2, Record 3...)
Partitioned into millions of small non-intersecting groups (Group A, Group B, Group C...)
Membership gradually changes over time, i.e. a record may be reassigned to…
Todd Owen
- 15,650
- 7
- 54
- 52
1
vote
0 answers
Elasticsearch - Java API - Get all id's, version, full index name and field with Point In Time slices
I am using elasticsearch 7.17 and I am trying to get all the document id's, version numbers, full index name (using alias in search) and another field. The data will eventually contain about 500 million records so I need to use a solution that can…
karen
- 893
- 2
- 13
- 38
1
vote
1 answer
What shall I do if the PIT in ElasticSearch is expired?
I'm trying using the Point In Time API for pagination implementation and I got the exception message below while using an expired pit id:
pplication exception: ResponseError: search_phase_execution_exception
Root causes:
…
LCB
- 971
- 9
- 22
1
vote
2 answers
How do I do a SQL join to get the latest data from table1 as of the date in table2?
I have two tables, call them "monthlyStoreCount" and…
MYK
- 1,988
- 7
- 30
1
vote
1 answer
How to Create a bacPac file from PIT Azure SQL
I have a requirement to basically beable to 'tag' PIT restores as to hold for longer (and then later use the restore on demand), the only way i can think to do this is basically figure out a way to export the requested Point-in-Time restore to a…
user8451292
- 53
- 1
- 5
1
vote
0 answers
ElasticSearch 7.10 using pit return duplicate ids in differnt pages
ElasticSearch 7.10 using pit return duplicate ids in differnt pages using pagination with page number and page size, this makes sence? I thougt that pit should prevent the effect of indexing new documents while doing searches
Doron Levi
- 458
- 4
- 16
1
vote
1 answer
How to create a Clone based on a previous state of the Azure Storage Account
I need to create a clone of an Azure storage account based on a particular time (not the latest). The source storage account won't be rollbacked to the particular time and make a clone of it. I need the source storage account be remain as it is and…
Sashin Sahasra
- 37
- 9
1
vote
0 answers
parameter storage for time-based simulations
we have a production application that depends on some business parameters such as thresholds, tax-rates, VAT etc. these parameters are subject to changes from time to time.
Therefore - we don't want to hard-code them but rather have them configured…
akiva
- 2,677
- 3
- 31
- 40
1
vote
1 answer
How to select Point In Time record
I have a MariaDB 10.2.21.
My table contains records that include a 'ChangeDate' field like this: '2019-09-18 10:57:26'.
I want to do a SELECT based on a timestamp, and get the nearest previous record to return.
This allows me to do a 'point-in-time'…
Szjoin
- 47
- 1
- 6
1
vote
1 answer
How can I restore AWS-RDS aurora database to a specified time in CLI?
I want to restore my Aurora database to a specified time. I've enabled the automated backups. I've tried the following script from the official user guide (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html):
aws rds…
user1552545
- 1,233
- 3
- 15
- 33