given a database named db:
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname='db'
AND state = 'idle in transaction'
mike@rbci:~$ psql -U postgres | |
psql (9.0.3) | |
Type "help" for help. | |
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; | |
UPDATE 1 | |
postgres=# \c template0 | |
You are now connected to database "template0". | |
template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; | |
UPDATE 1 |
PROJECT = "<your project>" | |
current-version: | |
@echo "Current version is `cat ${PROJECT}/__init__.py | awk -F '("|")' '{ print($$2)}'`" | |
build: | |
git stash | |
python setup.py sdist | |
- git stash pop |
#!/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. |
class FieldSelectionMixin(object): | |
""" | |
add ability to Resource to query specific fields. This works by | |
removing any fields not in the fields list provided by the fields | |
query parameter. | |
Programming Use: | |
class MyResource(FieldSelectionMixin, ModelResource): | |
... | |
(as with any normal resource) |
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" |
# -*- 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 |
{ | |
"Statement": [ | |
{ | |
"Sid": "AllowPublicRead", | |
"Effect": "Allow", | |
"Principal": { | |
"AWS": "*" | |
}, | |
"Action": "s3:GetObject", | |
"Resource": "arn:aws:s3:::bucket_name_here/*" |
# 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 | |
given a database named db:
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname='db'
AND state = 'idle in transaction'