---
# System prepended metadata

title: Update blobstore address SOP

---

# 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 
![](https://i.imgur.com/cGMHcXt.png)
2. Secret Management
![](https://i.imgur.com/cjTQ1Sy.png)
3. Remeber secret name,cluster,workspace,namespace than delete it
![](https://i.imgur.com/bEVqD40.png)
4. chose "+" than create new one
![](https://i.imgur.com/pSMHfVD.png)

### Restart deploy
1. find out which deploy use blobstore than restart 
```
kubectl -n (namespaceName) rollout restart deploy (deployName)
```