Will Jones drj42

drj42 / kube-registry.yaml

Created November 22, 2017 19:00 — forked from coco98/kube-registry.yaml

Docker registry on minikube

	apiVersion: v1
	kind: ReplicationController
	metadata:
	name: kube-registry-v0
	namespace: kube-system
	labels:
	k8s-app: kube-registry
	version: v0
	spec:
	replicas: 1

drj42 / postgres_queries_and_commands.sql

Last active August 29, 2018 20:17 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- long running queries
	SELECT
	pid,
	now() - pg_stat_activity.query_start AS duration,
	query,
	state
	FROM pg_stat_activity
	WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes'

	-- show running queries (9.2)

drj42 / types_and_roles_demo.sql

Created September 5, 2018 22:24 — forked from levlaz/types_and_roles_demo.sql

Create Types and Roles If Not Exist in PostgreSQL

	BEGIN;

	DO $$
	BEGIN
	IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'task_status') THEN
	create type task_status AS ENUM ('todo', 'doing', 'blocked', 'done');
	END IF;
	END
	$$;
	CREATE TABLE IF NOT EXISTS