API tools faq
paste
Guest User

Untitled

a guest
Oct 16th, 2018
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.02 KB | None | 0 0
raw download clone embed print report
  1. SELECT oid,* FROM pg_authid
  2.  
  3.  
  4. oid | rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcatupdate | rolcanlogin | rolconnlimit | rolpassword | rolvaliduntil
  5. ---------+------------------+----------+------------+---------------+-------------+--------------+-------------+--------------+-------------------------------------+---------------
  6. 10 | ubuntu | t | t | t | t | t | t | -1 | |
  7. 16384 | hotspare | t | t | f | f | t | t | -1 | CENSORED |
  8. 16385 | ADMINUSER | t | t | f | f | t | t | -1 | CENSORED |
  9. 16386 | postgres | t | t | f | f | t | t | -1 | CENSORED |
  10. 16387 | root | t | t | f | f | t | t | -1 | CENSORED |
  11. 3092706 | prodpublisherweb | t | t | f | f | t | t | -1 | CENSORED |
  12. 7701977 | rss | t | t | f | f | f | t | -1 | CENSORED | infinity
  13. (7 rows)
  14.  
  15.  
  16. /srv/pg_upgrade_dump_globals.sql
  17.  
  18.  
  19. --
  20. -- PostgreSQL database cluster dump
  21. --
  22.  
  23. \connect postgres
  24.  
  25. SET client_encoding = 'UTF8';
  26. SET standard_conforming_strings = off;
  27. SET escape_string_warning = off;
  28.  
  29. --
  30. -- Roles
  31. --
  32.  
  33.  
  34. -- For binary upgrade, must preserve pg_authid.oid
  35. SELECT binary_upgrade.set_next_pg_authid_oid('16384'::pg_catalog.oid);
  36.  
  37. CREATE ROLE hotspare;
  38. ALTER ROLE hotspare WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'CENSORED';
  39.  
  40. -- For binary upgrade, must preserve pg_authid.oid
  41. SELECT binary_upgrade.set_next_pg_authid_oid('16385'::pg_catalog.oid);
  42.  
  43. CREATE ROLE CENSORED;
  44. ALTER ROLE CENSORED WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'CENSORED';
  45.  
  46. -- For binary upgrade, must preserve pg_authid.oid
  47. SELECT binary_upgrade.set_next_pg_authid_oid('16386'::pg_catalog.oid);
  48.  
  49. ALTER ROLE postgres WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'CENSORED';
  50.  
  51. -- For binary upgrade, must preserve pg_authid.oid
  52. SELECT binary_upgrade.set_next_pg_authid_oid('3092706'::pg_catalog.oid);
  53.  
  54. CREATE ROLE prodpublisherweb;
  55. ALTER ROLE prodpublisherweb WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'CENSORED';
  56.  
  57. -- For binary upgrade, must preserve pg_authid.oid
  58. SELECT binary_upgrade.set_next_pg_authid_oid('16387'::pg_catalog.oid);
  59.  
  60. CREATE ROLE root;
  61. ALTER ROLE root WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'CENSORED';
  62.  
  63. -- For binary upgrade, must preserve pg_authid.oid
  64. SELECT binary_upgrade.set_next_pg_authid_oid('7701977'::pg_catalog.oid);
  65.  
  66. CREATE ROLE rss;
  67. ALTER ROLE rss WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'CENSORED' VALID UNTIL 'infinity';
  68.  
  69. -- For binary upgrade, must preserve pg_authid.oid
  70. SELECT binary_upgrade.set_next_pg_authid_oid('10'::pg_catalog.oid);
  71.  
  72. CREATE ROLE ubuntu;
  73. ALTER ROLE ubuntu WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN NOREPLICATION;
  74.  
  75.  
  76.  
  77.  
  78.  
  79.  
  80. --
  81. -- Database creation
  82. --
  83.  
  84. CREATE DATABASE "CUSTOMER1-production-monitor" WITH TEMPLATE = template0 OWNER = CENSORED;
  85. -- For binary upgrade, set datfrozenxid.
  86. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'CUSTOMER1-production-monitor';
  87. CREATE DATABASE "CUSTOMER1studios-production-monitor" WITH TEMPLATE = template0 OWNER = CENSORED;
  88. -- For binary upgrade, set datfrozenxid.
  89. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'CUSTOMER1studios-production-monitor';
  90. CREATE DATABASE "gs-production-monitor" WITH TEMPLATE = template0 OWNER = CENSORED;
  91. -- For binary upgrade, set datfrozenxid.
  92. UPDATE pg_catalog.pg_database SET datfrozenxid = '600001717' WHERE datname = 'CUSTOMER4-production-monitor';
  93. CREATE DATABASE "launchpad-production-monitor" WITH TEMPLATE = template0 OWNER = CENSORED;
  94. -- For binary upgrade, set datfrozenxid.
  95. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'launchpad-production-monitor';
  96. CREATE DATABASE "CUSTOMER3-production-monitor" WITH TEMPLATE = template0 OWNER = CENSORED;
  97. -- For binary upgrade, set datfrozenxid.
  98. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'CUSTOMER3-production-monitor';
  99. CREATE DATABASE prodadvertiser WITH TEMPLATE = template0 OWNER = CENSORED;
  100. -- For binary upgrade, set datfrozenxid.
  101. UPDATE pg_catalog.pg_database SET datfrozenxid = '600006466' WHERE datname = 'prodadvertiser';
  102. CREATE DATABASE prodapi WITH TEMPLATE = template0 OWNER = CENSORED;
  103. -- For binary upgrade, set datfrozenxid.
  104. UPDATE pg_catalog.pg_database SET datfrozenxid = '553446275' WHERE datname = 'prodapi';
  105. CREATE DATABASE prodbus WITH TEMPLATE = template0 OWNER = CENSORED;
  106. -- For binary upgrade, set datfrozenxid.
  107. UPDATE pg_catalog.pg_database SET datfrozenxid = '600005395' WHERE datname = 'prodbus';
  108. CREATE DATABASE proddelayedmessages WITH TEMPLATE = template0 OWNER = CENSORED;
  109. -- For binary upgrade, set datfrozenxid.
  110. UPDATE pg_catalog.pg_database SET datfrozenxid = '560553651' WHERE datname = 'proddelayedmessages';
  111. CREATE DATABASE proddepuypricing WITH TEMPLATE = template0 OWNER = CENSORED;
  112. -- For binary upgrade, set datfrozenxid.
  113. UPDATE pg_catalog.pg_database SET datfrozenxid = '600007596' WHERE datname = 'prodCUSTOMER6pricing';
  114. CREATE DATABASE prodframesets WITH TEMPLATE = template0 OWNER = CENSORED;
  115. -- For binary upgrade, set datfrozenxid.
  116. UPDATE pg_catalog.pg_database SET datfrozenxid = '550001717' WHERE datname = 'prodframesets';
  117. CREATE DATABASE prodhiring WITH TEMPLATE = template0 OWNER = CENSORED;
  118. -- For binary upgrade, set datfrozenxid.
  119. UPDATE pg_catalog.pg_database SET datfrozenxid = '550000741' WHERE datname = 'prodhiring';
  120. CREATE DATABASE prodjobs WITH TEMPLATE = template0 OWNER = CENSORED;
  121. -- For binary upgrade, set datfrozenxid.
  122. UPDATE pg_catalog.pg_database SET datfrozenxid = '600005657' WHERE datname = 'prodjobs';
  123. CREATE DATABASE prodplayerprofiles WITH TEMPLATE = template0 OWNER = CENSORED;
  124. -- For binary upgrade, set datfrozenxid.
  125. UPDATE pg_catalog.pg_database SET datfrozenxid = '561108737' WHERE datname = 'prodplayerprofiles';
  126. CREATE DATABASE prodplayerprofileslog WITH TEMPLATE = template0 OWNER = CENSORED;
  127. -- For binary upgrade, set datfrozenxid.
  128. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'prodplayerprofileslog';
  129. CREATE DATABASE prodplaylist WITH TEMPLATE = template0 OWNER = CENSORED;
  130. -- For binary upgrade, set datfrozenxid.
  131. UPDATE pg_catalog.pg_database SET datfrozenxid = '550199403' WHERE datname = 'prodplaylist';
  132. CREATE DATABASE prodpubliclog WITH TEMPLATE = template0 OWNER = CENSORED;
  133. -- For binary upgrade, set datfrozenxid.
  134. UPDATE pg_catalog.pg_database SET datfrozenxid = '580086909' WHERE datname = 'prodpubliclog';
  135. CREATE DATABASE prodpublisher WITH TEMPLATE = template0 OWNER = CENSORED;
  136. -- For binary upgrade, set datfrozenxid.
  137. UPDATE pg_catalog.pg_database SET datfrozenxid = '580944535' WHERE datname = 'prodpublisher';
  138. CREATE DATABASE prodsecurity WITH TEMPLATE = template0 OWNER = CENSORED;
  139. -- For binary upgrade, set datfrozenxid.
  140. UPDATE pg_catalog.pg_database SET datfrozenxid = '550001717' WHERE datname = 'prodsecurity';
  141. CREATE DATABASE prodslugserver WITH TEMPLATE = template0 OWNER = CENSORED;
  142. -- For binary upgrade, set datfrozenxid.
  143. UPDATE pg_catalog.pg_database SET datfrozenxid = '600007379' WHERE datname = 'prodslugserver';
  144. CREATE DATABASE prodsyndication WITH TEMPLATE = template0 OWNER = CENSORED;
  145. -- For binary upgrade, set datfrozenxid.
  146. UPDATE pg_catalog.pg_database SET datfrozenxid = '600007153' WHERE datname = 'prodsyndication';
  147. CREATE DATABASE produseroperations WITH TEMPLATE = template0 OWNER = CENSORED;
  148. -- For binary upgrade, set datfrozenxid.
  149. UPDATE pg_catalog.pg_database SET datfrozenxid = '573575709' WHERE datname = 'produseroperations';
  150. CREATE DATABASE prodvisitors WITH TEMPLATE = template0 OWNER = CENSORED;
  151. -- For binary upgrade, set datfrozenxid.
  152. UPDATE pg_catalog.pg_database SET datfrozenxid = '600004841' WHERE datname = 'prodvisitors';
  153. CREATE DATABASE prodwarehouse WITH TEMPLATE = template0 OWNER = CENSORED;
  154. -- For binary upgrade, set datfrozenxid.
  155. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'prodwarehouse';
  156. CREATE DATABASE prodwarehousebd WITH TEMPLATE = template0 OWNER = CENSORED;
  157. -- For binary upgrade, set datfrozenxid.
  158. UPDATE pg_catalog.pg_database SET datfrozenxid = '600001717' WHERE datname = 'prodwarehousebd';
  159. CREATE DATABASE prodwarehouseds WITH TEMPLATE = template0 OWNER = CENSORED;
  160. -- For binary upgrade, set datfrozenxid.
  161. UPDATE pg_catalog.pg_database SET datfrozenxid = '550001717' WHERE datname = 'prodwarehouseds';
  162. CREATE DATABASE prodwarehousegs WITH TEMPLATE = template0 OWNER = CENSORED;
  163. -- For binary upgrade, set datfrozenxid.
  164. UPDATE pg_catalog.pg_database SET datfrozenxid = '550001717' WHERE datname = 'prodwarehousegs';
  165. CREATE DATABASE prodwarehouseCUSTOMER3 WITH TEMPLATE = template0 OWNER = CENSORED;
  166. -- For binary upgrade, set datfrozenxid.
  167. UPDATE pg_catalog.pg_database SET datfrozenxid = '600001717' WHERE datname = 'prodwarehouseCUSTOMER3';
  168. CREATE DATABASE prodwarehouseCUSTOMER3sk WITH TEMPLATE = template0 OWNER = CENSORED;
  169. -- For binary upgrade, set datfrozenxid.
  170. UPDATE pg_catalog.pg_database SET datfrozenxid = '600001717' WHERE datname = 'prodwarehouseCUSTOMER3sk';
  171. CREATE DATABASE prodwarehouseCUSTOMER2 WITH TEMPLATE = template0 OWNER = CENSORED;
  172. -- For binary upgrade, set datfrozenxid.
  173. UPDATE pg_catalog.pg_database SET datfrozenxid = '550001717' WHERE datname = 'prodwarehouseCUSTOMER2';
  174. CREATE DATABASE prodwarehousetopco WITH TEMPLATE = template0 OWNER = CENSORED;
  175. -- For binary upgrade, set datfrozenxid.
  176. UPDATE pg_catalog.pg_database SET datfrozenxid = '546972583' WHERE datname = 'prodwarehouseCUSTOMER5';
  177. CREATE DATABASE CUSTOMER2api WITH TEMPLATE = template0 OWNER = ubuntu;
  178. -- For binary upgrade, set datfrozenxid.
  179. UPDATE pg_catalog.pg_database SET datfrozenxid = '571750898' WHERE datname = 'CUSTOMER2api';
  180. CREATE DATABASE CUSTOMER2apilog WITH TEMPLATE = template0 OWNER = CENSORED;
  181. -- For binary upgrade, set datfrozenxid.
  182. UPDATE pg_catalog.pg_database SET datfrozenxid = '579833702' WHERE datname = 'CUSTOMER2apilog';
  183. CREATE DATABASE CUSTOMER2playerprofiles WITH TEMPLATE = template0 OWNER = CENSORED;
  184. -- For binary upgrade, set datfrozenxid.
  185. UPDATE pg_catalog.pg_database SET datfrozenxid = '600012607' WHERE datname = 'CUSTOMER2playerprofiles';
  186. CREATE DATABASE CUSTOMER2playerprofileslog WITH TEMPLATE = template0 OWNER = CENSORED;
  187. -- For binary upgrade, set datfrozenxid.
  188. UPDATE pg_catalog.pg_database SET datfrozenxid = '600000680' WHERE datname = 'CUSTOMER2playerprofileslog';
  189. CREATE DATABASE CUSTOMER2playlist WITH TEMPLATE = template0 OWNER = ubuntu;
  190. -- For binary upgrade, set datfrozenxid.
  191. UPDATE pg_catalog.pg_database SET datfrozenxid = '592198140' WHERE datname = 'CUSTOMER2playlist';
  192. CREATE DATABASE CUSTOMER2public WITH TEMPLATE = template0 OWNER = ubuntu;
  193. -- For binary upgrade, set datfrozenxid.
  194. UPDATE pg_catalog.pg_database SET datfrozenxid = '568727642' WHERE datname = 'CUSTOMER2public';
  195. CREATE DATABASE CUSTOMER2publiclog WITH TEMPLATE = template0 OWNER = ubuntu;
  196. -- For binary upgrade, set datfrozenxid.
  197. UPDATE pg_catalog.pg_database SET datfrozenxid = '584955865' WHERE datname = 'CUSTOMER2publiclog';
  198. CREATE DATABASE CUSTOMER2publicrssupdater WITH TEMPLATE = template0 OWNER = ubuntu;
  199. -- For binary upgrade, set datfrozenxid.
  200. UPDATE pg_catalog.pg_database SET datfrozenxid = '600011414' WHERE datname = 'CUSTOMER2publicrssupdater';
  201. CREATE DATABASE CUSTOMER2searchlog WITH TEMPLATE = template0 OWNER = CENSORED;
  202. -- For binary upgrade, set datfrozenxid.
  203. UPDATE pg_catalog.pg_database SET datfrozenxid = '545125039' WHERE datname = 'CUSTOMER2searchlog';
  204. CREATE DATABASE CUSTOMER2slugserver WITH TEMPLATE = template0 OWNER = ubuntu;
  205. -- For binary upgrade, set datfrozenxid.
  206. UPDATE pg_catalog.pg_database SET datfrozenxid = '600011602' WHERE datname = 'CUSTOMER2slugserver';
  207. CREATE DATABASE CUSTOMER2useroperations WITH TEMPLATE = template0 OWNER = ubuntu;
  208. -- For binary upgrade, set datfrozenxid.
  209. UPDATE pg_catalog.pg_database SET datfrozenxid = '600011876' WHERE datname = 'CUSTOMER2useroperations';
  210. CREATE DATABASE CUSTOMER2visitors WITH TEMPLATE = template0 OWNER = ubuntu;
  211. -- For binary upgrade, set datfrozenxid.
  212. UPDATE pg_catalog.pg_database SET datfrozenxid = '600012111' WHERE datname = 'CUSTOMER2visitors';
  213. REVOKE ALL ON DATABASE template1 FROM PUBLIC;
  214. REVOKE ALL ON DATABASE template1 FROM ubuntu;
  215. GRANT ALL ON DATABASE template1 TO ubuntu;
  216. GRANT CONNECT ON DATABASE template1 TO PUBLIC;
  217. CREATE DATABASE ubuntu WITH TEMPLATE = template0 OWNER = ubuntu;
  218. -- For binary upgrade, set datfrozenxid.
  219. UPDATE pg_catalog.pg_database SET datfrozenxid = '592328202' WHERE datname = 'ubuntu';
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!