skeptrunedev · November 5, 2024 02:21
diff --git a/postgres-migration-status-and-kill.sql b/postgres-migration-status-and-kill.sql
 -- the output of this command will have a table with a pid colummn
 -- find the migration you want to stop and copy it's pid for step 2

 SELECT *
 FROM pg_stat_activity
 WHERE state = 'active';

 -- use the pid you copied from the previous output here instead of 7844

 SELECT pg_cancel_backend(7844);
	-- the output of this command will have a table with a pid colummn
	-- find the migration you want to stop and copy it's pid for step 2

	SELECT *
	FROM pg_stat_activity
	WHERE state = 'active';

	-- use the pid you copied from the previous output here instead of 7844

	SELECT pg_cancel_backend(7844);