postgres database and schema creation

pgsetup

su - postgres
psql
CREATE ROLE stash WITH LOGIN PASSWORD 'stash' VALID UNTIL 'infinity';
CREATE DATABASE stash WITH ENCODING='UTF8' OWNER=stash CONNECTION LIMIT=-1;
\connect stash;
CREATE SCHEMA stash AUTHORIZATION stash;
ALTER USER stash SET SEARCH_PATH TO stash;

Kill all sessions except current:

SELECT pg_terminate_backend(pid) FROM pg_stat_get_activity(NULL::integer) WHERE datid=(SELECT oid from pg_database where datname = 'stash');