New to KubeDB? Please start here.
Don’t know how to take continuous backup? Check this tutorial on Continuous Archiving.
KubeDB supports PostgreSQL database initialization. When you create a new Postgres object, you can provide existing WAL files to restore from by “replaying” the log entries. Users can now restore from any one of s3, gcs, azure, or swift as cloud backup provider.
What is Continuous Archiving
PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/ subdirectory of the cluster’s data directory. The existence of the log makes it possible to restore from the backed-up WAL files to bring the system back to a last known state.
To know more about continuous archiving, please refer to the ofiicial postgres document on this topic.
List of supported Cloud Providers for PostgresVersion CRDs
| Name | Version | S3 | MinIO | GCS | Azure | Swift | Local |
|---|---|---|---|---|---|---|---|
| 9.6-v2 | 9.6 | ✓ | ✗ | ✓ | ✗ | ✗ | ✗ |
| 9.6.7-v2 | 9.6.7 | ✓ | ✗ | ✓ | ✗ | ✗ | ✗ |
| 10.2-v2 | 10.2 | ✓ | ✗ | ✓ | ✗ | ✗ | ✗ |
| 10.6 | 10.6 | ✓ | ✗ | ✓ | ✗ | ✗ | ✗ |
| 11.1 | 11.1 | ✓ | ✗ | ✓ | ✗ | ✗ | ✗ |
| 9.6-v3 | 9.6 | ✓ | ✗ | ✓ | ✓ | ✓ | ✗ |
| 9.6.7-v3 | 9.6.7 | ✓ | ✗ | ✓ | ✓ | ✓ | ✗ |
| 10.2-v3 | 10.2 | ✓ | ✗ | ✓ | ✓ | ✓ | ✗ |
| 10.6-v1 | 10.6 | ✓ | ✗ | ✓ | ✓ | ✓ | ✗ |
| 11.1-v1 | 11.1 | ✓ | ✗ | ✓ | ✓ | ✓ | ✗ |
| 9.6-v4 | 9.6 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 9.6.7-v4 | 9.6.7 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 10.2-v4 | 10.2 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 10.6-v2 | 10.6 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 11.1-v2 | 11.1 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 11.2 | 11.2 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 9.6-v5 | 9.6 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 9.6.7-v5 | 9.6.7 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 10.2-v5 | 10.2 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 10.6-v3 | 10.6 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 11.1-v3 | 11.1 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| 11.2-v1 | 11.2 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |