kill postgres process code example

Example 1: postgres kill running query

--Stop the query normally
SELECT pg_cancel_backend(pid);

--Terminate immediately
SELECT pg_terminate_backend(pid);

Example 2: postgres auto listening when kill pid

brew services stop postgres