Will Jones drj42

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

## postgres_queries_and_commands.sql
-- 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)

## types_and_roles_demo.sql
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
	apiVersion: v1
	kind: ReplicationController
	metadata:
	name: kube-registry-v0
	namespace: kube-system
	labels:
	k8s-app: kube-registry
	version: v0
	spec:
	replicas: 1
	-- 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)
	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