Alauda support for PostgreSQL

Instance Details

TOC

Introduction

View detailed information about the PostgreSQL instance, including:

  • Basic information and status of the instance
  • Database connection information
  • Resource configuration and storage information
  • Scheduling configuration
  • Related Kubernetes resources
NOTE
  1. Viewing Secrets requires the appropriate Kubernetes RBAC permissions.
  2. The information displayed on the instance detail page comes from the Kubernetes CRD and the actual running status.
  3. Some configuration information cannot be modified after the instance is created.

Procedure

CLI
Web Console

View Basic Instance Information

kubectl -n <namespace> get postgresql <instance_name> -o yaml

View Database Connection Information

# View PostgreSQL user password
kubectl -n <namespace> get secret <instance_name>.credentials.postgresql.acid.zalan.do -o yaml

# View connection endpoint
kubectl -n <namespace> get svc <instance_name>

View Resource Configuration

# View Pod resource limits
kubectl -n <namespace> get pod <instance_name>-0 -o yaml | grep resources -A 5

# View storage configuration
kubectl -n <namespace> get pvc pgdata-<instance_name>-0 -o yaml

View Scheduling Configuration

# View node affinity
kubectl -n <namespace> get postgresql <instance_name> -o yaml | grep affinity -A 10

# View tolerations
kubectl -n <namespace> get postgresql <instance_name> -o yaml | grep tolerations -A 5