Top
Enterprise Postgres 18 for Kubernetes User's Guide

6.7.4 Using SUPERUSER

If SUPERUSER privileges are required for database operation, you can obtain the password for SUPERUSER "postgres" by following the steps below.

  1. Get the base64-encoded password from the Secret with the same name as the FEPCluster custom resource name.

    Example) When the FEPCluster custom resource name is new-fep

    $ kubectl get -o yaml secret new-fep | grep PG_ADMIN_PASSWORD
      PG_ADMIN_PASSWORD: YWRtaW4tcGFzc3dvcmQ=
  2. Decode the obtained password.

    $ echo YWRtaW4tcGFzc3dvcmQ= | base64 -d
    admin-password

Note

In order to prevent SUPERUSER from being used by a third party, please set Kubernetes Role permissions to the Secret so that only the database administrator can refer it.