given a database named db:
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname='db'
AND state = 'idle in transaction'
given a database named db:
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname='db'
AND state = 'idle in transaction'
set realname = "Scott Burlington" | |
set from = "scott@burlresearch.com" | |
set imap_user = "scott@burlresearch.com" | |
set imap_pass = "XXX" | |
set smtp_url = "smtp://scott@burlresearch.com@smtp.gmail.com:587/" | |
set smtp_pass = "XXX" | |
set folder = imaps://imap.gmail.com/ | |
set spoolfile = "+INBOX" | |
set postponed = "+[Gmail]/Drafts" |
# Hello, and welcome to makefile basics. | |
# | |
# You will learn why `make` is so great, and why, despite its "weird" syntax, | |
# it is actually a highly expressive, efficient, and powerful way to build | |
# programs. | |
# | |
# Once you're done here, go to | |
# http://www.gnu.org/software/make/manual/make.html | |
# to learn SOOOO much more. |
# -*- coding: utf-8 -*- | |
import codecs | |
import subprocess | |
from fdfgen import forge_fdf | |
from django.core.exceptions import ImproperlyConfigured | |
from django.template import engines | |
from django.template.backends.base import BaseEngine | |
from django.template.engine import Engine, _dirs_undefined |
#!/bin/bash | |
# This is free and unencumbered software released into the public domain. | |
# | |
# This script is designed to be run daily by cron. Please run it with randomness in its timing to | |
# avoid load spikes at Let's Encrypt. One example, running between midnight at 2 AM, would be: | |
# | |
# 0 0 * * * sleep $[(RANDOM % 115)+5]m ; /usr/sbin/letsencrypt-renew.sh | |
# | |
# If you aren't using Nginx, adjust the startServer and stopServer methods to suit. Also, you could | |
# use the webroot method. |
# based on https://gist.github.com/blueyed/4fb0a807104551f103e6 | |
# and on https://gist.github.com/TauPan/aec52e398d7288cb5a62895916182a9f (gistspection!) | |
from django.core.management import call_command | |
from django.db import connection | |
from django.db.migrations.executor import MigrationExecutor | |
import pytest | |
# use ImageMagick convert | |
# the order is important. the density argument applies to input.pdf and resize and rotate to output.pdf | |
convert -density 90 input.pdf -rotate 0.5 -attenuate 0.2 +noise Multiplicative -colorspace Gray output.pdf |