Ubuntu, Pgadmin(delete DB) - An error has occurred: database is being accessed by other users.

Channel:
Ambar Hasbiyatmoko
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=8Jj0cykrrz4


Duration: 4:47
1,501 views
9

i get an error message when trying to delete DB postgre in pgadmin (UBUNTU) :

Pgadmin III
An error has occurred:

ERROR: database "the_test" is being accessed by other users
DETAIL: There is 4 other session using the database.

-----
In this video will help you how to fix that error.
- open terminal, connect to pgsql,
- run script :
REVOKE CONNECT ON DATABASE dbname FROM PUBLIC, username;

- then :
see this video for details.



Other Videos By Ambar Hasbiyatmoko


2017-04-10Displaying PHP errors when : The localhost page isn’t working (on Ubuntu)
2017-04-08Virtualbox - Port forward web server (guest to host)
2017-04-07Slick jquery slider - Fix image width
2017-04-05Virtualbox on centos 7 - Kernel driver not installed (rc=-1908)
2017-04-04Codeigniter + Nginx configuration on Ubuntu 16.04
2017-04-04install nginx + php5.6 on Ubuntu 16.04
2017-04-03Virtualbox error - Failed to create the hard disk storage, with UUID already exists
2017-04-03Mariadb (Ubuntu) - ERROR 1698 (28000): Access denied for user 'root'@'localhost'
2017-04-02Virtualbox on Centos 7 - No package kernel-devel-3.10.0-327 available.
2017-03-31Install virtualbox on Centos 7
2017-03-28Ubuntu, Pgadmin(delete DB) - An error has occurred: database is being accessed by other users.
2017-03-27Wordpress (https error) - mixed content was loaded over https but requested an insecure script
2017-03-23Virtualbox error - failed to install the extension pack
2017-03-22Javascript Tutorial - How to get object length
2017-03-22Virtualbox problem - no devices available (usb devices - flashdisk)
2017-03-21Virtualbox error (in ubuntu) - implementation of the USB 2.0 controller not found!
2017-03-19Dota 2 - Witch Doctor Carry, 24 kills LOL
2017-03-18PHPExcel error (in ubuntu) - The localhost page isn’t working when trying to save .xlsx
2017-03-17PHP Trick - merge two image with PHP in ubuntu 16.04
2017-03-16Moodle - Install moodle 3.2 in Ubuntu 16.04
2017-03-15Steam - your local dota 2 files conflict with the ones stored in the steam cloud.


Tags:
drop
delete
db
database
postgresql
pgadmin
ubuntu
linux
error
users
session
terminal
query
script