Re: Database in use?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Carol Walter <walterc@xxxxxxxxxxx> writes:
> This has happened or is happening to me again, only this time, it's a  
> database that I just created.  I restored another database into a test  
> database.  One of the tables is empty.  I want to drop the test  
> database and create a new one.  When I try to drop the test database,  
> I get this error -
> template1=# drop database km_tezt;
> ERROR:  database "km_tezt" is being accessed by other users

> template1=# select * from pg_prepared_xacts;
>   transaction | gid | prepared | owner | database
> -------------+-----+----------+-------+----------
> (0 rows)

Nothing in pg_stat_activity either?

			regards, tom lane

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux