You are looking at the documentation of a prior release. To read the documentation of the latest release, please
visit here.
New to KubeDB? Please start here.
Don’t know how to take continuous backup? Check this tutorial on Continuous Archiving.
PostgreSQL Initialization from WAL files
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 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Next Steps
- Learn about restoring from Amazon S3.
- Learn about restoring from S3 MinIO.
- Learn about restoring from Google Cloud Storage.
- Learn about restoring from Azure Storage.
- Learn about restoring from OpenStack Object Storage (Swift).
- Learn about restoring from Local Storage.
- Learn about initializing PostgreSQL with Script.
- Monitor your PostgreSQL database with KubeDB using built-in Prometheus.
- Monitor your PostgreSQL database with KubeDB using Prometheus operator.
- Want to hack on KubeDB? Check our contribution guidelines.