Answers for "postgresql drop database force"

SQL
2

drop database postgres

DROP DATABASE base_de_datos;

// SI SALE ESTE MESAJE DE ERROR HAGA LOS PASOS QUE ESTAN A CONTINUACION
ERROR: database "base_de_datos" is being accessed by other users
SQL state: 55006
Detail: There is 1 other session using the database.
----------------------------------------------------------------------

// primer paso ---------------------------------
SELECT *
FROM pg_stat_activity
WHERE datname = 'base_de_datos';

//segundo paso --------------------------------
SELECT
	pg_terminate_backend (pg_stat_activity.pid)
FROM
	pg_stat_activity
WHERE
	pg_stat_activity.datname = 'base_de_datos';
    
// tercer paso --------------------------------
DROP DATABASE 'base_de_datos';

// retira las comillas si no funciona
DROP DATABASE base_de_datos;
Posted by: Guest on April-05-2021
0

how to hard drop database in postgres

It means another user is accessing the database. Simply restart PostgreSQL. This command will do the trick

root@kalilinux:~#sudo service postgresql restart
Then try dropping the database:

postgres=# drop database test_database;
This will do the trick.
Posted by: Guest on April-14-2021

Code answers related to "postgresql drop database force"

Code answers related to "SQL"

Browse Popular Code Answers by Language