Versions Compared

Old Version 4

changes.mady.by.user Aaron Hossain

Saved on

compared with

New Version 5

changes.mady.by.user Aaron Hossain

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
/usr/bin/test `/usr/bin/pgrep -f 'idle in transaction' | \ 
/usr/bin/wc \-l ` \-gt 20 && /usr/bin/pkill \-o \-f 'idle in transaction'

In English: every minute, if there are more than 20 "idle in
transaction" Postgres processes, it kills the oldest one.

...

Code Block
/bin/test `/usr/local/bin/pgrep -f '127.0.0.1' | \ 
/usr/bin/wc \-l ` \-gt 20 && /usr/local/bin/pkill \-n \-f '127.0.0.1'