Skip to content

Instantly share code, notes, and snippets.

@kofno
Created May 8, 2009 01:50
Show Gist options
  • Save kofno/108548 to your computer and use it in GitHub Desktop.
Save kofno/108548 to your computer and use it in GitHub Desktop.
--
-- PostgreSQL database cluster dump
--
\connect postgres
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET escape_string_warning = 'off';
--
-- Roles
--
CREATE ROLE blog;
ALTER ROLE blog WITH NOSUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN PASSWORD 'md5126ac9f6149081eb0e97c2e939eaad52';
CREATE ROLE ftime;
ALTER ROLE ftime WITH NOSUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN PASSWORD 'md5c56ac2854530add41b2c0f194e44cd1c';
CREATE ROLE hibuser;
ALTER ROLE hibuser WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md59c90dcdfea04742e73c3456a604743d4';
CREATE ROLE invoicer;
ALTER ROLE invoicer WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md52934b274e848006263e3b66b8bdc996f';
CREATE ROLE nedss;
ALTER ROLE nedss WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md560d03a377796c188cd7e591bd5b435bf';
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
CREATE ROLE rails;
ALTER ROLE rails WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md54d003d1435f0827cfe18ac2d2a3979e7';
CREATE ROLE ryan;
ALTER ROLE ryan WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md53eaacbac57f4d0ee2d6a3f1ed4648c66';
ALTER ROLE ryan SET client_min_messages TO 'notice';
CREATE ROLE trisano_dw;
ALTER ROLE trisano_dw WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md5fde4b66b27d25053c732cc6ebcaec18c';
ALTER ROLE trisano_dw SET search_path TO trisano;
CREATE ROLE trisano_guy;
ALTER ROLE trisano_guy WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md55e64d64146ebe95d719aad169c42a709';
CREATE ROLE trisano_user;
ALTER ROLE trisano_user WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md5683bccd75610aeb8e6850aa91a566db9';
--
-- PostgreSQL database cluster dump complete
--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment