Unable to delete a database from postgres

Description of issue

ERROR: database <db-name> is being accessed by other users

DETAIL: There is 1 other session using the database.

You have to terminate the connections to the database first, for that you can use the command.

1. SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname='TARGET_DB';

Then run the command to delete database -

1. drop databases <db-name>

• Related Articles

• Unable to login with admin password or reset devtron admin password

  Debug: Run the command for admin credentials and use it for login in dashboard: kubectl -n devtroncd get secret devtron-secret -o jsonpath='{.data.ADMIN_PASSWORD}' | base64 -d If you are getting an error message of "invalid username or password" or ...

• Getting UPGRADE FAILED: cannot patch "postgresql-postgresql" while upgrading Devtron to newer versions

  Debug: Make sure to annotate and label all the Devtron resources. Description of error Error: UPGRADE FAILED: cannot patch "postgresql-postgresql" with kind StatefulSet: StatefulSet.apps "postgresql-postgresql" is invalid: spec: Forbidden: updates to ...

• Refreshing ArgoCD Certificates When Expired

  1. Edit ArgoCD Secret Use kubectl edit to edit the ArgoCD secret in the appropriate namespace (devtroncd in this case). Find the data section and delete the lines for tls.crt and tls.key: kubectl edit secret argocd-secret -n devtroncd 2. Delete Lines ...

• Major Changes Coming to Bitnami's Container Image Catalog

  On August 28th, 2025, Bitnami will implement significant changes to its public container image catalog, affecting how developers and organizations access and use their popular Docker images and Helm charts. What's Changing The transformation centers ...

• NGINX Ingress Helm Chart Install/Upgrade Sync Stuck with Argo CD

  ? Problem Overview Context: Using Argo CD to manage ingress-nginx Helm chart. Issue Introduced: In chart version 4.12.3+, pre-sync and post-sync Jobs have ttlSecondsAfterFinished: 0, meaning the Job itself is deleted immediately after completion. ...