Airbyte: Enabling point-in-time recovery on our internal database
Affected components: Data Sync
Timeline of updates
- identified
Maintenance: Enable the point-in-time recovery option on the main Postgres database. This should be a zero-downtime operation but we noticed that connections were dropping while testing in the Staging Environment. Our backend systems do reconnect but there could be an impact on transactions that are in-flight. We estimate that the operation will take 20min to 30min, but the connection dropping only occurred during a smaller time frame of a couple of minutes in the beginning. Why does it matter: - Reduces data loss from hours to seconds in case of a database failure - Enables us to conduct database recovery exercises without downtime as required per SOC II and ISO 27001..
- identified
Maintenance is now in progress.
- completed
Maintenance has completed successfully.
Archive proof
Rewindex commits each version of an incident it captures to a daily checkpoint, chains it to the day before, and has the checkpoint timestamped by FreeTSA and DigiCert. That proves this record existed by then and has not been changed since, by anyone, Rewindex included.
How the archive is checked, and what it cannot prove.
First version captured
In the 2026-10-17 checkpoint, timestamped by FreeTSA and DigiCert on . Record hash
f6edffb8966b8fff…
Impact, status and times are the vendor’s own, as last archived. View on status.airbyte.com (opens in new tab).
Cite this
Maintenance posted by Airbyte, started 2023-10-12 22:00 UTC, resolved after 30 min, 3 update(s).
- Title
- Enabling point-in-time recovery on our internal database
- Vendor
- Airbyte
- Date
- URL
- https://rewindex.com/company/airbyte/incidents/clnlttgpk52939bbok4eeqjrk0
Airbyte profileRecent Airbyte incidentsAll outages on October 12, 2023Airbyte in October 2023MarkdownJSON