Guest User

Untitled

a guest
Mar 6th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. --
  2. -- PostgreSQL database cluster dump
  3. --
  4.  
  5. \connect postgres
  6.  
  7. SET client_encoding = 'UTF8';
  8. SET standard_conforming_strings = off;
  9. SET escape_string_warning = 'off';
  10.  
  11. --
  12. -- Roles
  13. --
  14.  
  15. CREATE ROLE blog;
  16. ALTER ROLE blog WITH NOSUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN PASSWORD 'md5126ac9f6149081eb0e97c2e939eaad52';
  17. CREATE ROLE ftime;
  18. ALTER ROLE ftime WITH NOSUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN PASSWORD 'md5c56ac2854530add41b2c0f194e44cd1c';
  19. CREATE ROLE hibuser;
  20. ALTER ROLE hibuser WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md59c90dcdfea04742e73c3456a604743d4';
  21. CREATE ROLE invoicer;
  22. ALTER ROLE invoicer WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md52934b274e848006263e3b66b8bdc996f';
  23. CREATE ROLE nedss;
  24. ALTER ROLE nedss WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md560d03a377796c188cd7e591bd5b435bf';
  25. CREATE ROLE postgres;
  26. ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
  27. CREATE ROLE rails;
  28. ALTER ROLE rails WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md54d003d1435f0827cfe18ac2d2a3979e7';
  29. CREATE ROLE ryan;
  30. ALTER ROLE ryan WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN PASSWORD 'md53eaacbac57f4d0ee2d6a3f1ed4648c66';
  31. ALTER ROLE ryan SET client_min_messages TO 'notice';
  32. CREATE ROLE trisano_dw;
  33. ALTER ROLE trisano_dw WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md5fde4b66b27d25053c732cc6ebcaec18c';
  34. ALTER ROLE trisano_dw SET search_path TO trisano;
  35. CREATE ROLE trisano_guy;
  36. ALTER ROLE trisano_guy WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md55e64d64146ebe95d719aad169c42a709';
  37. CREATE ROLE trisano_user;
  38. ALTER ROLE trisano_user WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD 'md5683bccd75610aeb8e6850aa91a566db9';
  39.  
  40.  
  41.  
  42.  
  43. --
  44. -- PostgreSQL database cluster dump complete
  45. --
Add Comment
Please, Sign In to add comment