# Update blobstore address SOP
### update blobstore IP by postgresql db

1. get postgresql password by file /opt/ensaas/playbooks/backup/credentials/
2. (find stolon proxy)

    kubectl -n ensaas-db get pod

3.

     kubectl -n ensaas-db exec postgres-stolon-proxy-<proxypodname> -it  /bin/bash 

4.

    psql -h 127.0.0.1 -U postgres postgres 

5.

    (enter passowrd)

6. (find blobstore database)

    \l

7.

    \c blobstore-sm-<????>

8. (find out which credential_pid you want change)

    select * from credentials;

9.

    update credentials set external_hosts='(IP):(port)' where credential_pid='(your credential_pid number)';

### Recrete secret
1. login to service portal
2. Secret Management
3. Remeber secret name,cluster,workspace,namespace than delete it
4. chose "+" than create new one

### Restart deploy
1. find out which deploy use blobstore than restart

kubectl -n (namespaceName) rollout restart deploy (deployName)