Re: How to disconnect a single user in Postgresql 8.2.5 from a database

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

 



Josh Kupershmidt <schmiddy@xxxxxxxxx> writes:
> pg_terminate_backend() is just a SQL wrapper around:
>    kill -SIGTERM [backend PID]

> For versions before 8.4: if you can SSH in to the server, run the
> above on the PID of the backend your user is connected to, and that
> should terminate their connection.

The reason the function isn't there before 8.4 is that that's not
promised to work before 8.4 ... most of the time it will work, but
once in awhile you could get nasty side-effects.

			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