Re: Who's attached to the database?

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

 



Carol Walter <walterc@xxxxxxxxxxx> writes:
> I'm trying to drop a database and I'm getting an error that says that  
> the database is being accessed by other users.  Is there a way I can  
> find out who these users are or if there really is a user accessing it?

pg_stat_activity ... or if you turned that off, "ps auxww | grep postgres"
(or local equivalent) might help.

			regards, tom lane


[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