DEFINITIONS
Definitions More Info.
Definition ID
852
Title
POSTGRESQL
Category
NOTES
Definition
Kill only one session
Definition Description
https://stackoverflow.com/questions/35319597/how-to-stop-kill-a-query-in-postgresql
Find the process you want to kill 9.1 de
select * from pg_stat_activity
9.1 den sonra
SELECT
*
FROM
pg_stat_activity
WHERE
state = 'active';
TO kill type:
SELECT
pg_cancel_backend( 9646 )
If the process cannot be killed, try:
SELECT
pg_terminate_backend(
)
RecordBy
cunay
Record Date
27-06-2018 21:30:48
Düzenle
Kopyala
Sil