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 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |