Administering EDB Postgres service
Service configuration
| Task | Required permissions | Details |
|---|---|---|
| Setting up access to EDB Postgres service instances | Instance administrator |
You can connect to the EDB Postgres service from a Kubernetes cluster. |
| Configuring TLS for EDB Postgres with a custom resource | Instance administrator |
You can enable TLS to encrypt connections to your EDB Postgres instance using your own custom TLS certificates and the database's custom resource. |
Database configuration
| Task | Required permissions | Details |
|---|---|---|
| Giving users access to the EDB Postgres database | Instance administrator |
By default, only the user who creates the EDB Postgres database has access to the database. This user must give other users access to the database. |
| Creating a custom EDB Postgres user name and password | Instance administrator |
You can create custom credentials for application users and superusers to connect to your EDB Postgres database instances on IBM Cloud Pak for Data. |
Security
| Task | Required permissions | Details |
|---|---|---|
| Exporting Cloud Pak for Data audit records to a security information and event management solution | Not supported |
Resource management
| Task | Required permissions | Details |
|---|---|---|
| Manually scaling resources for services | Not supported | |
| Automatically scaling resources for services | Not supported | |
| Shutting down and restarting services | Not supported |
Backup and restore
| Task | Required permissions | Details |
|---|---|---|
| Backing up and restoring Cloud Pak for Data | Cluster administrator | Choose the correct method to back up and restore Cloud Pak for Data. |
| Performing physical backup and restore for the EDB Postgres service | Cluster administrator |
EDB Postgres uses dedicated backup and restore utilities. |
| Setting up continuous backup and restore for the EDB Postgres service | Cluster administrator |
You can configure EDB Postgres to allow backup and restore with S3 storage. |