Workaround for password synchronization issues

We recommend using nais-cli for rotating password for your Postgres database user.

nais postgres password rotate appname

Manually¶

Retrieve the password from the secret google-sql-MYAPP in your namespace (the password is base64 encoded):

kubectl get secret google-sql-<MYAPP> -o jsonpath="{ .data['<YOUR PASSWORD VARIABLE>'] }" | base64 -d

Log in to the Google Cloud Console and set the password manually for the application user in the sql instance: SQL -> DB_INSTANCE -> Users -> USERNAME -> Change password