Created
May 8, 2009 01:50
-
-
Save kofno/108548 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- 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