Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.20 KB | None | 0 0
  1. xxx@yyy:~$ pg_dumpall -v > backup
  2. pg_dumpall: executing SELECT pg_catalog.set_config('search_path', '', false)
  3. pg_dumpall: executing SELECT oid, rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin, rolconnlimit, rolpassword, rolvaliduntil, rolreplication, rolbypassrls, pg_catalog.shobj_description(oid, '
  4. pg_authid') as rolcomment, rolname = current_user AS is_current_user FROM pg_authid WHERE rolname !~ '^pg_' ORDER BY 2
  5. pg_dumpall: executing SELECT provider, label FROM pg_catalog.pg_shseclabel WHERE classoid = 'pg_catalog.pg_authid'::pg_catalog.regclass AND objoid = '16386'
  6. pg_dumpall: executing SELECT provider, label FROM pg_catalog.pg_shseclabel WHERE classoid = 'pg_catalog.pg_authid'::pg_catalog.regclass AND objoid = '10'
  7. pg_dumpall: executing SELECT provider, label FROM pg_catalog.pg_shseclabel WHERE classoid = 'pg_catalog.pg_authid'::pg_catalog.regclass AND objoid = '16384'
  8. pg_dumpall: executing SELECT setconfig[1] FROM pg_db_role_setting WHERE setdatabase = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'bbb')
  9. pg_dumpall: executing SELECT setconfig[1] FROM pg_db_role_setting WHERE setdatabase = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'postgres')
  10. pg_dumpall: executing SELECT setconfig[1] FROM pg_db_role_setting WHERE setdatabase = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'aaa')
  11. pg_dumpall: executing SELECT setconfig[2] FROM pg_db_role_setting WHERE setdatabase = 0 AND setrole = (SELECT oid FROM pg_authid WHERE rolname = 'aaa')
  12. pg_dumpall: executing SELECT ur.rolname AS roleid, um.rolname AS member, a.admin_option, ug.rolname AS grantor FROM pg_auth_members a LEFT JOIN pg_authid ur on ur.oid = a.roleid LEFT JOIN pg_authid um on um.oid =
  13. a.member LEFT JOIN pg_authid ug on ug.oid = a.grantor WHERE NOT (ur.rolname ~ '^pg_' AND um.rolname ~ '^pg_')ORDER BY 1,2,3
  14. pg_dumpall: executing SELECT oid, spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, pg_catalog.pg_tablespace_location(oid), (SELECT pg_catalog.array_agg(acl) FROM (SELECT pg_catalog.unnest(coalesce(spcacl
  15. ,pg_catalog.acldefault('t',spcowner))) AS acl EXCEPT SELECT pg_catalog.unnest(pg_catalog.acldefault('t',spcowner))) as foo)AS spcacl,(SELECT pg_catalog.array_agg(acl) FROM (SELECT pg_catalog.unnest(pg_catalog.acld
  16. efault('t',spcowner)) AS acl EXCEPT SELECT pg_catalog.unnest(coalesce(spcacl,pg_catalog.acldefault('t',spcowner)))) as foo)AS rspcacl,array_to_string(spcoptions, ', '),pg_catalog.shobj_description(oid, 'pg_tablesp
  17. ace') FROM pg_catalog.pg_tablespace WHERE spcname !~ '^pg_' ORDER BY 1
  18. pg_dumpall: executing SELECT pg_encoding_to_char(encoding), datcollate, datctype FROM pg_database WHERE datname = 'template0'
  19. pg_dumpall: executing SELECT datname, coalesce(rolname, (select rolname from pg_authid where oid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datcollate, datctype,
  20. datfrozenxid, datminmxid, datistemplate, (SELECT pg_catalog.array_agg(acl ORDER BY acl::text COLLATE "C") FROM ( SELECT pg_catalog.unnest(coalesce(datacl,pg_catalog.acldefault('d',datdba))) AS acl EXCEPT SELE
  21. CT pg_catalog.unnest(pg_catalog.acldefault('d',datdba))) as datacls)AS datacl, (SELECT pg_catalog.array_agg(acl ORDER BY acl::text COLLATE "C") FROM ( SELECT pg_catalog.unnest(pg_catalog.acldefault('d',datdba))
  22. AS acl EXCEPT SELECT pg_catalog.unnest(coalesce(datacl,pg_catalog.acldefault('d',datdba)))) as rdatacls)AS rdatacl, datconnlimit, (SELECT spcname FROM pg_tablespace t WHERE t.oid = d.dattablespace) AS dattablesp
  23. ace FROM pg_database d LEFT JOIN pg_authid u ON (datdba = u.oid) WHERE datallowconn ORDER BY 1
  24. pg_dumpall: executing SELECT setconfig[1] FROM pg_db_role_setting WHERE setrole = 0 AND setdatabase = (SELECT oid FROM pg_database WHERE datname = 'postgres')
  25. pg_dumpall: executing SELECT setconfig[1] FROM pg_db_role_setting WHERE setrole = 0 AND setdatabase = (SELECT oid FROM pg_database WHERE datname = 'mydb')
  26. pg_dumpall: executing SELECT setconfig[1] FROM pg_db_role_setting WHERE setrole = 0 AND setdatabase = (SELECT oid FROM pg_database WHERE datname = 'template1')
  27. pg_dumpall: executing SELECT rolname, datname, unnest(setconfig) FROM pg_db_role_setting, pg_authid u, pg_database WHERE setrole = u.oid AND setdatabase = pg_database.oid
  28. pg_dumpall: executing SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1
  29. pg_dumpall: dumping database "postgres"...
  30. pg_dumpall: running ""/usr/lib/postgresql/10/bin/pg_dump" -v -Fp ' dbname=postgres'"
  31. pg_dump: last built-in OID is 16383
  32. pg_dump: reading extensions
  33. pg_dump: identifying extension members
  34. pg_dump: reading schemas
  35. pg_dump: reading user-defined tables
  36. pg_dump: reading user-defined functions
  37. pg_dump: reading user-defined types
  38. pg_dump: reading procedural languages
  39. pg_dump: reading user-defined aggregate functions
  40. pg_dump: reading user-defined operators
  41. pg_dump: reading user-defined access methods
  42. pg_dump: reading user-defined operator classes
  43. pg_dump: reading user-defined operator families
  44. pg_dump: reading user-defined text search parsers
  45. pg_dump: reading user-defined text search templates
  46. pg_dump: reading user-defined text search dictionaries
  47. pg_dump: reading user-defined text search configurations
  48. pg_dump: reading user-defined foreign-data wrappers
  49. pg_dump: reading user-defined foreign servers
  50. pg_dump: reading default privileges
  51. pg_dump: reading user-defined collations
  52. pg_dump: reading user-defined conversions
  53. pg_dump: reading type casts
  54. pg_dump: reading transforms
  55. pg_dump: reading table inheritance information
  56. pg_dump: reading event triggers
  57. pg_dump: finding extension tables
  58. pg_dump: finding inheritance relationships
  59. pg_dump: reading column info for interesting tables
  60. pg_dump: finding the columns and types of table "pg_catalog.pg_stat_database"
  61. pg_dump: flagging inherited columns in subtables
  62. pg_dump: reading indexes
  63. pg_dump: reading extended statistics
  64. pg_dump: reading constraints
  65. pg_dump: reading triggers
  66. pg_dump: reading rewrite rules
  67. pg_dump: reading policies
  68. pg_dump: reading publications
  69. pg_dump: reading publication membership
  70. pg_dump: reading subscriptions
  71. pg_dump: reading large objects
  72. pg_dump: reading dependency data
  73. pg_dump: saving encoding = UTF8
  74. pg_dump: saving standard_conforming_strings = on
  75. pg_dump: saving search_path =
  76. pg_dump: saving database definition
  77. pg_dump: creating COMMENT "DATABASE postgres"
  78. pg_dump: creating SCHEMA "public"
  79. pg_dump: creating COMMENT "SCHEMA public"
  80. pg_dump: creating EXTENSION "plpgsql"
  81. pg_dump: creating COMMENT "EXTENSION plpgsql"
  82. pg_dump: creating ACL "pg_catalog.TABLE pg_stat_database"
  83. pg_dumpall: dumping database "mydb"...
  84. pg_dumpall: running ""/usr/lib/postgresql/10/bin/pg_dump" -v -Fp ' dbname=mydb'"
  85. pg_dump: last built-in OID is 16383
  86. pg_dump: reading extensions
  87. pg_dump: identifying extension members
  88. pg_dump: reading schemas
  89. pg_dump: reading user-defined tables
  90. pg_dump: reading user-defined functions
  91. pg_dump: reading user-defined types
  92. pg_dump: reading procedural languages
  93. pg_dump: reading user-defined aggregate functions
  94. pg_dump: reading user-defined operators
  95. pg_dump: reading user-defined access methods
  96. pg_dump: reading user-defined operator classes
  97. pg_dump: reading user-defined operator families
  98. pg_dump: reading user-defined text search parsers
  99. pg_dump: reading user-defined text search templates
  100. pg_dump: reading user-defined text search dictionaries
  101. pg_dump: reading user-defined text search configurations
  102. pg_dump: reading user-defined foreign-data wrappers
  103. pg_dump: reading user-defined foreign servers
  104. pg_dump: reading default privileges
  105. pg_dump: reading user-defined collations
  106. pg_dump: reading user-defined conversions
  107. pg_dump: reading type casts
  108. pg_dump: reading transforms
  109. pg_dump: reading table inheritance information
  110. pg_dump: reading event triggers
  111. pg_dump: finding extension tables
  112. pg_dump: finding inheritance relationships
  113. pg_dump: reading column info for interesting tables
  114. pg_dump: finding the columns and types of table "x.bull"
  115. pg_dump: finding default expressions of table "x.bull"
  116. pg_dump: finding the columns and types of table "x.rooster"
  117. pg_dump: finding default expressions of table "x.rooster"
  118. pg_dump: finding check constraints for table "x.rooster"
  119. pg_dump: finding the columns and types of table "x.mouse"
  120. pg_dump: finding default expressions of table "x.mouse"
  121. pg_dump: finding check constraints for table "x.mouse"
  122. pg_dump: finding the columns and types of table "x.matview1_mouse_000001"
  123. pg_dump: finding the columns and types of table "x.matview2_aaa_1_000001"
  124. pg_dump: finding the columns and types of table "x.matview2_bbb_1_000001"
  125. pg_dump: finding the columns and types of table "x.matview2_ccc_1_000001"
  126. pg_dump: finding the columns and types of table "x.matview2_ddd_1_000001"
  127. pg_dump: finding the columns and types of table "x.matview2_eee_1_000001"
  128. pg_dump: finding the columns and types of table "x.matview2_aaa_2_000001"
  129. pg_dump: finding the columns and types of table "x.matview2_bbb_2_000001"
  130. pg_dump: finding the columns and types of table "x.matview2_ccc_2_000001"
  131. pg_dump: finding the columns and types of table "x.matview2_ddd_2_000001"
  132. pg_dump: finding the columns and types of table "x.matview2_eee_2_000001"
  133. pg_dump: finding the columns and types of table "x.matview2_aaa_4_000001"
  134. pg_dump: finding the columns and types of table "x.matview2_bbb_4_000001"
  135. pg_dump: finding the columns and types of table "x.matview2_ccc_4_000001"
  136. pg_dump: finding the columns and types of table "x.matview2_ddd_4_000001"
  137. pg_dump: finding the columns and types of table "x.matview2_eee_4_000001"
  138. pg_dump: finding the columns and types of table "x.matview1_fff_000001"
  139. pg_dump: finding the columns and types of table "x.matview2_fff_1_000001"
  140. pg_dump: finding the columns and types of table "x.matview2_fff_2_000001"
  141. pg_dump: finding the columns and types of table "x.matview2_fff_4_000001"
  142. pg_dump: finding the columns and types of table "x.matview1_mouse_000007"
  143. pg_dump: finding the columns and types of table "x.matview2_aaa_1_000007"
  144. pg_dump: finding the columns and types of table "x.matview2_bbb_1_000007"
  145. pg_dump: finding the columns and types of table "x.matview2_ccc_1_000007"
  146. pg_dump: finding the columns and types of table "x.matview2_ddd_1_000007"
  147. pg_dump: finding the columns and types of table "x.matview2_eee_1_000007"
  148. pg_dump: finding the columns and types of table "x.matview2_aaa_2_000007"
  149. pg_dump: finding the columns and types of table "x.matview2_bbb_2_000007"
  150. pg_dump: finding the columns and types of table "x.matview2_ccc_2_000007"
  151. pg_dump: finding the columns and types of table "x.matview2_ddd_2_000007"
  152. pg_dump: finding the columns and types of table "x.matview2_eee_2_000007"
  153. pg_dump: finding the columns and types of table "x.matview2_aaa_4_000007"
  154. pg_dump: finding the columns and types of table "x.matview2_bbb_4_000007"
  155. pg_dump: finding the columns and types of table "x.matview2_ccc_4_000007"
  156. pg_dump: finding the columns and types of table "x.matview2_ddd_4_000007"
  157. pg_dump: finding the columns and types of table "x.matview2_eee_4_000007"
  158. pg_dump: finding the columns and types of table "x.matview1_fff_000007"
  159. pg_dump: finding the columns and types of table "x.matview2_fff_1_000007"
  160. pg_dump: finding the columns and types of table "x.matview2_fff_2_000007"
  161. pg_dump: finding the columns and types of table "x.matview2_fff_4_000007"
  162. pg_dump: finding the columns and types of table "x.matview1_mouse_003652"
  163. pg_dump: finding the columns and types of table "x.matview2_aaa_1_003652"
  164. pg_dump: finding the columns and types of table "x.matview2_bbb_1_003652"
  165. pg_dump: finding the columns and types of table "x.matview2_ccc_1_003652"
  166. pg_dump: finding the columns and types of table "x.matview2_ddd_1_003652"
  167. pg_dump: finding the columns and types of table "x.matview2_eee_1_003652"
  168. pg_dump: finding the columns and types of table "x.matview2_aaa_2_003652"
  169. pg_dump: finding the columns and types of table "x.matview2_bbb_2_003652"
  170. pg_dump: finding the columns and types of table "x.matview2_ccc_2_003652"
  171. pg_dump: finding the columns and types of table "x.matview2_ddd_2_003652"
  172. pg_dump: finding the columns and types of table "x.matview2_eee_2_003652"
  173. pg_dump: finding the columns and types of table "x.matview2_aaa_4_003652"
  174. pg_dump: finding the columns and types of table "x.matview2_bbb_4_003652"
  175. pg_dump: finding the columns and types of table "x.matview2_ccc_4_003652"
  176. pg_dump: finding the columns and types of table "x.matview2_ddd_4_003652"
  177. pg_dump: finding the columns and types of table "x.matview2_eee_4_003652"
  178. pg_dump: finding the columns and types of table "x.matview1_fff_003652"
  179. pg_dump: finding the columns and types of table "x.matview2_fff_1_003652"
  180. pg_dump: finding the columns and types of table "x.matview2_fff_2_003652"
  181. pg_dump: finding the columns and types of table "x.matview2_fff_4_003652"
  182. pg_dump: finding the columns and types of table "x.matview2_rhino_2_000007"
  183. pg_dump: finding the columns and types of table "x.matview2_rhino_4_000007"
  184. pg_dump: finding the columns and types of table "x.matview2_rhino_2_003652"
  185. pg_dump: finding the columns and types of table "x.matview2_rhino_4_003652"
  186. pg_dump: finding the columns and types of table "x.matview2_rhino_2_000001"
  187. pg_dump: finding the columns and types of table "x.matview2_rhino_4_000001"
  188. pg_dump: finding the columns and types of table "x.iguana"
  189. pg_dump: finding the columns and types of table "x.rhino"
  190. pg_dump: finding the columns and types of table "x.iguana_2018060100_to_2018060106"
  191. pg_dump: finding check constraints for table "x.iguana_2018060100_to_2018060106"
  192. pg_dump: finding the columns and types of table "x.iguana_2018060106_to_2018060112"
  193. pg_dump: finding check constraints for table "x.iguana_2018060106_to_2018060112"
  194. pg_dump: finding the columns and types of table "x.iguana_2018060112_to_2018060118"
  195. pg_dump: finding check constraints for table "x.iguana_2018060112_to_2018060118"
  196. pg_dump: finding the columns and types of table "x.iguana_2018060118_to_2018060200"
  197. pg_dump: finding check constraints for table "x.iguana_2018060118_to_2018060200"
  198. pg_dump: finding the columns and types of table "x.iguana_2018060200_to_2018060206"
  199. pg_dump: finding check constraints for table "x.iguana_2018060200_to_2018060206"
  200. pg_dump: finding the columns and types of table "x.iguana_2018060206_to_2018060212"
  201. pg_dump: finding check constraints for table "x.iguana_2018060206_to_2018060212"
  202. pg_dump: finding the columns and types of table "x.iguana_2018060212_to_2018060218"
  203. pg_dump: finding check constraints for table "x.iguana_2018060212_to_2018060218"
  204. pg_dump: finding the columns and types of table "x.iguana_2018060218_to_2018060300"
  205. pg_dump: finding check constraints for table "x.iguana_2018060218_to_2018060300"
  206. pg_dump: finding the columns and types of table "x.iguana_2018060300_to_2018060306"
  207. pg_dump: finding check constraints for table "x.iguana_2018060300_to_2018060306"
  208. pg_dump: finding the columns and types of table "x.iguana_2018060306_to_2018060312"
  209. pg_dump: finding check constraints for table "x.iguana_2018060306_to_2018060312"
  210. pg_dump: finding the columns and types of table "x.iguana_2018060312_to_2018060318"
  211. pg_dump: finding check constraints for table "x.iguana_2018060312_to_2018060318"
  212. pg_dump: finding the columns and types of table "x.iguana_2018060318_to_2018060400"
  213. pg_dump: finding check constraints for table "x.iguana_2018060318_to_2018060400"
  214. pg_dump: finding the columns and types of table "x.iguana_2018060400_to_2018060406"
  215. pg_dump: finding check constraints for table "x.iguana_2018060400_to_2018060406"
  216. pg_dump: finding the columns and types of table "x.iguana_2018060406_to_2018060412"
  217. pg_dump: finding check constraints for table "x.iguana_2018060406_to_2018060412"
  218. pg_dump: finding the columns and types of table "x.iguana_2018060412_to_2018060418"
  219. pg_dump: finding check constraints for table "x.iguana_2018060412_to_2018060418"
  220. pg_dump: finding the columns and types of table "x.iguana_2018060418_to_2018060500"
  221. pg_dump: finding check constraints for table "x.iguana_2018060418_to_2018060500"
  222. pg_dump: finding the columns and types of table "x.iguana_2018060500_to_2018060506"
  223. pg_dump: finding check constraints for table "x.iguana_2018060500_to_2018060506"
  224. pg_dump: finding the columns and types of table "x.iguana_2018060506_to_2018060512"
  225. pg_dump: finding check constraints for table "x.iguana_2018060506_to_2018060512"
  226. pg_dump: finding the columns and types of table "x.iguana_2018060512_to_2018060518"
  227. pg_dump: finding check constraints for table "x.iguana_2018060512_to_2018060518"
  228. pg_dump: finding the columns and types of table "x.iguana_2018060518_to_2018060600"
  229. pg_dump: finding check constraints for table "x.iguana_2018060518_to_2018060600"
  230. pg_dump: finding the columns and types of table "x.iguana_2018060600_to_2018060606"
  231. pg_dump: finding check constraints for table "x.iguana_2018060600_to_2018060606"
  232. pg_dump: finding the columns and types of table "x.iguana_2018060606_to_2018060612"
  233. pg_dump: finding check constraints for table "x.iguana_2018060606_to_2018060612"
  234. pg_dump: finding the columns and types of table "x.iguana_2018060612_to_2018060618"
  235. pg_dump: finding check constraints for table "x.iguana_2018060612_to_2018060618"
  236. pg_dump: finding the columns and types of table "x.iguana_2018060618_to_2018060700"
  237. pg_dump: finding check constraints for table "x.iguana_2018060618_to_2018060700"
  238. pg_dump: finding the columns and types of table "x.iguana_2018060700_to_2018060706"
  239. pg_dump: finding check constraints for table "x.iguana_2018060700_to_2018060706"
  240. pg_dump: finding the columns and types of table "x.iguana_2018060706_to_2018060712"
  241. pg_dump: finding check constraints for table "x.iguana_2018060706_to_2018060712"
  242. pg_dump: finding the columns and types of table "x.iguana_2018060712_to_2018060718"
  243. pg_dump: finding check constraints for table "x.iguana_2018060712_to_2018060718"
  244. pg_dump: finding the columns and types of table "x.iguana_2018060718_to_2018060800"
  245. pg_dump: finding check constraints for table "x.iguana_2018060718_to_2018060800"
  246. pg_dump: finding the columns and types of table "x.iguana_2018060800_to_2018060806"
  247. pg_dump: finding check constraints for table "x.iguana_2018060800_to_2018060806"
  248. pg_dump: finding the columns and types of table "x.iguana_2018060806_to_2018060812"
  249. pg_dump: finding check constraints for table "x.iguana_2018060806_to_2018060812"
  250. pg_dump: finding the columns and types of table "x.iguana_2018060812_to_2018060818"
  251. pg_dump: finding check constraints for table "x.iguana_2018060812_to_2018060818"
  252. pg_dump: finding the columns and types of table "x.iguana_2018060818_to_2018060900"
  253. pg_dump: finding check constraints for table "x.iguana_2018060818_to_2018060900"
  254. pg_dump: finding the columns and types of table "x.iguana_2018060900_to_2018060906"
  255. pg_dump: finding check constraints for table "x.iguana_2018060900_to_2018060906"
  256. pg_dump: finding the columns and types of table "x.iguana_2018060906_to_2018060912"
  257. pg_dump: finding check constraints for table "x.iguana_2018060906_to_2018060912"
  258. pg_dump: finding the columns and types of table "x.iguana_2018060912_to_2018060918"
  259. pg_dump: finding check constraints for table "x.iguana_2018060912_to_2018060918"
  260. pg_dump: finding the columns and types of table "x.iguana_2018060918_to_2018061000"
  261. pg_dump: finding check constraints for table "x.iguana_2018060918_to_2018061000"
  262. pg_dump: finding the columns and types of table "x.iguana_2018061000_to_2018061006"
  263. pg_dump: finding check constraints for table "x.iguana_2018061000_to_2018061006"
  264. pg_dump: finding the columns and types of table "x.iguana_2018061006_to_2018061012"
  265. pg_dump: finding check constraints for table "x.iguana_2018061006_to_2018061012"
  266. pg_dump: finding the columns and types of table "x.iguana_2018061012_to_2018061018"
  267. pg_dump: finding check constraints for table "x.iguana_2018061012_to_2018061018"
  268. pg_dump: finding the columns and types of table "x.iguana_2018061018_to_2018061100"
  269. pg_dump: finding check constraints for table "x.iguana_2018061018_to_2018061100"
  270. pg_dump: finding the columns and types of table "x.iguana_2018061100_to_2018061106"
  271. pg_dump: finding check constraints for table "x.iguana_2018061100_to_2018061106"
  272. pg_dump: finding the columns and types of table "x.iguana_2018061106_to_2018061112"
  273. pg_dump: finding check constraints for table "x.iguana_2018061106_to_2018061112"
  274. pg_dump: finding the columns and types of table "x.iguana_2018061112_to_2018061118"
  275. pg_dump: finding check constraints for table "x.iguana_2018061112_to_2018061118"
  276. pg_dump: finding the columns and types of table "x.iguana_2018061118_to_2018061200"
  277. pg_dump: finding check constraints for table "x.iguana_2018061118_to_2018061200"
  278. pg_dump: finding the columns and types of table "x.iguana_2018061200_to_2018061206"
  279. pg_dump: finding check constraints for table "x.iguana_2018061200_to_2018061206"
  280. pg_dump: finding the columns and types of table "x.iguana_2018061206_to_2018061212"
  281. pg_dump: finding check constraints for table "x.iguana_2018061206_to_2018061212"
  282. pg_dump: finding the columns and types of table "x.iguana_2018061212_to_2018061218"
  283. pg_dump: finding check constraints for table "x.iguana_2018061212_to_2018061218"
  284. pg_dump: finding the columns and types of table "x.iguana_2018061218_to_2018061300"
  285. pg_dump: finding check constraints for table "x.iguana_2018061218_to_2018061300"
  286. pg_dump: finding the columns and types of table "x.iguana_2018061300_to_2018061306"
  287. pg_dump: finding check constraints for table "x.iguana_2018061300_to_2018061306"
  288. pg_dump: finding the columns and types of table "x.iguana_2018061306_to_2018061312"
  289. pg_dump: finding check constraints for table "x.iguana_2018061306_to_2018061312"
  290. pg_dump: finding the columns and types of table "x.iguana_2018061312_to_2018061318"
  291. pg_dump: finding check constraints for table "x.iguana_2018061312_to_2018061318"
  292. pg_dump: finding the columns and types of table "x.iguana_2018061318_to_2018061400"
  293. pg_dump: finding check constraints for table "x.iguana_2018061318_to_2018061400"
  294. pg_dump: finding the columns and types of table "x.rhino_2018060100_to_2018060106"
  295. pg_dump: finding check constraints for table "x.rhino_2018060100_to_2018060106"
  296. pg_dump: finding the columns and types of table "x.rhino_2018060106_to_2018060112"
  297. pg_dump: finding check constraints for table "x.rhino_2018060106_to_2018060112"
  298. pg_dump: finding the columns and types of table "x.rhino_2018060112_to_2018060118"
  299. pg_dump: finding check constraints for table "x.rhino_2018060112_to_2018060118"
  300. pg_dump: finding the columns and types of table "x.rhino_2018060118_to_2018060200"
  301. pg_dump: finding check constraints for table "x.rhino_2018060118_to_2018060200"
  302. pg_dump: finding the columns and types of table "x.rhino_2018060200_to_2018060206"
  303. pg_dump: finding check constraints for table "x.rhino_2018060200_to_2018060206"
  304. pg_dump: finding the columns and types of table "x.rhino_2018060206_to_2018060212"
  305. pg_dump: finding check constraints for table "x.rhino_2018060206_to_2018060212"
  306. pg_dump: finding the columns and types of table "x.rhino_2018060212_to_2018060218"
  307. pg_dump: finding check constraints for table "x.rhino_2018060212_to_2018060218"
  308. pg_dump: finding the columns and types of table "x.rhino_2018060218_to_2018060300"
  309. pg_dump: finding check constraints for table "x.rhino_2018060218_to_2018060300"
  310. pg_dump: finding the columns and types of table "x.rhino_2018060300_to_2018060306"
  311. pg_dump: finding check constraints for table "x.rhino_2018060300_to_2018060306"
  312. pg_dump: finding the columns and types of table "x.rhino_2018060306_to_2018060312"
  313. pg_dump: finding check constraints for table "x.rhino_2018060306_to_2018060312"
  314. pg_dump: finding the columns and types of table "x.rhino_2018060312_to_2018060318"
  315. pg_dump: finding check constraints for table "x.rhino_2018060312_to_2018060318"
  316. pg_dump: finding the columns and types of table "x.rhino_2018060318_to_2018060400"
  317. pg_dump: finding check constraints for table "x.rhino_2018060318_to_2018060400"
  318. pg_dump: finding the columns and types of table "x.rhino_2018060400_to_2018060406"
  319. pg_dump: finding check constraints for table "x.rhino_2018060400_to_2018060406"
  320. pg_dump: finding the columns and types of table "x.rhino_2018060406_to_2018060412"
  321. pg_dump: finding check constraints for table "x.rhino_2018060406_to_2018060412"
  322. pg_dump: finding the columns and types of table "x.rhino_2018060412_to_2018060418"
  323. pg_dump: finding check constraints for table "x.rhino_2018060412_to_2018060418"
  324. pg_dump: finding the columns and types of table "x.rhino_2018060418_to_2018060500"
  325. pg_dump: finding check constraints for table "x.rhino_2018060418_to_2018060500"
  326. pg_dump: finding the columns and types of table "x.rhino_2018060500_to_2018060506"
  327. pg_dump: finding check constraints for table "x.rhino_2018060500_to_2018060506"
  328. pg_dump: finding the columns and types of table "x.rhino_2018060506_to_2018060512"
  329. pg_dump: finding check constraints for table "x.rhino_2018060506_to_2018060512"
  330. pg_dump: finding the columns and types of table "x.rhino_2018060512_to_2018060518"
  331. pg_dump: finding check constraints for table "x.rhino_2018060512_to_2018060518"
  332. pg_dump: finding the columns and types of table "x.rhino_2018060518_to_2018060600"
  333. pg_dump: finding check constraints for table "x.rhino_2018060518_to_2018060600"
  334. pg_dump: finding the columns and types of table "x.rhino_2018060600_to_2018060606"
  335. pg_dump: finding check constraints for table "x.rhino_2018060600_to_2018060606"
  336. pg_dump: finding the columns and types of table "x.rhino_2018060606_to_2018060612"
  337. pg_dump: finding check constraints for table "x.rhino_2018060606_to_2018060612"
  338. pg_dump: finding the columns and types of table "x.rhino_2018060612_to_2018060618"
  339. pg_dump: finding check constraints for table "x.rhino_2018060612_to_2018060618"
  340. pg_dump: finding the columns and types of table "x.rhino_2018060618_to_2018060700"
  341. pg_dump: finding check constraints for table "x.rhino_2018060618_to_2018060700"
  342. pg_dump: finding the columns and types of table "x.rhino_2018060700_to_2018060706"
  343. pg_dump: finding check constraints for table "x.rhino_2018060700_to_2018060706"
  344. pg_dump: finding the columns and types of table "x.rhino_2018060706_to_2018060712"
  345. pg_dump: finding check constraints for table "x.rhino_2018060706_to_2018060712"
  346. pg_dump: finding the columns and types of table "x.rhino_2018060712_to_2018060718"
  347. pg_dump: finding check constraints for table "x.rhino_2018060712_to_2018060718"
  348. pg_dump: finding the columns and types of table "x.rhino_2018060718_to_2018060800"
  349. pg_dump: finding check constraints for table "x.rhino_2018060718_to_2018060800"
  350. pg_dump: finding the columns and types of table "x.rhino_2018060800_to_2018060806"
  351. pg_dump: finding check constraints for table "x.rhino_2018060800_to_2018060806"
  352. pg_dump: finding the columns and types of table "x.rhino_2018060806_to_2018060812"
  353. pg_dump: finding check constraints for table "x.rhino_2018060806_to_2018060812"
  354. pg_dump: finding the columns and types of table "x.rhino_2018060812_to_2018060818"
  355. pg_dump: finding check constraints for table "x.rhino_2018060812_to_2018060818"
  356. pg_dump: finding the columns and types of table "x.rhino_2018060818_to_2018060900"
  357. pg_dump: finding check constraints for table "x.rhino_2018060818_to_2018060900"
  358. pg_dump: finding the columns and types of table "x.rhino_2018060900_to_2018060906"
  359. pg_dump: finding check constraints for table "x.rhino_2018060900_to_2018060906"
  360. pg_dump: finding the columns and types of table "x.rhino_2018060906_to_2018060912"
  361. pg_dump: finding check constraints for table "x.rhino_2018060906_to_2018060912"
  362. pg_dump: finding the columns and types of table "x.rhino_2018060912_to_2018060918"
  363. pg_dump: finding check constraints for table "x.rhino_2018060912_to_2018060918"
  364. pg_dump: finding the columns and types of table "x.rhino_2018060918_to_2018061000"
  365. pg_dump: finding check constraints for table "x.rhino_2018060918_to_2018061000"
  366. pg_dump: finding the columns and types of table "x.rhino_2018061000_to_2018061006"
  367. pg_dump: finding check constraints for table "x.rhino_2018061000_to_2018061006"
  368. pg_dump: finding the columns and types of table "x.rhino_2018061006_to_2018061012"
  369. pg_dump: finding check constraints for table "x.rhino_2018061006_to_2018061012"
  370. pg_dump: finding the columns and types of table "x.rhino_2018061012_to_2018061018"
  371. pg_dump: finding check constraints for table "x.rhino_2018061012_to_2018061018"
  372. pg_dump: finding the columns and types of table "x.rhino_2018061018_to_2018061100"
  373. pg_dump: finding check constraints for table "x.rhino_2018061018_to_2018061100"
  374. pg_dump: finding the columns and types of table "x.rhino_2018061100_to_2018061106"
  375. pg_dump: finding check constraints for table "x.rhino_2018061100_to_2018061106"
  376. pg_dump: finding the columns and types of table "x.rhino_2018061106_to_2018061112"
  377. pg_dump: finding check constraints for table "x.rhino_2018061106_to_2018061112"
  378. pg_dump: finding the columns and types of table "x.rhino_2018061112_to_2018061118"
  379. pg_dump: finding check constraints for table "x.rhino_2018061112_to_2018061118"
  380. pg_dump: finding the columns and types of table "x.rhino_2018061118_to_2018061200"
  381. pg_dump: finding check constraints for table "x.rhino_2018061118_to_2018061200"
  382. pg_dump: finding the columns and types of table "x.rhino_2018061200_to_2018061206"
  383. pg_dump: finding check constraints for table "x.rhino_2018061200_to_2018061206"
  384. pg_dump: finding the columns and types of table "x.rhino_2018061206_to_2018061212"
  385. pg_dump: finding check constraints for table "x.rhino_2018061206_to_2018061212"
  386. pg_dump: finding the columns and types of table "x.rhino_2018061212_to_2018061218"
  387. pg_dump: finding check constraints for table "x.rhino_2018061212_to_2018061218"
  388. pg_dump: finding the columns and types of table "x.rhino_2018061218_to_2018061300"
  389. pg_dump: finding check constraints for table "x.rhino_2018061218_to_2018061300"
  390. pg_dump: finding the columns and types of table "x.rhino_2018061300_to_2018061306"
  391. pg_dump: finding check constraints for table "x.rhino_2018061300_to_2018061306"
  392. pg_dump: finding the columns and types of table "x.rhino_2018061306_to_2018061312"
  393. pg_dump: finding check constraints for table "x.rhino_2018061306_to_2018061312"
  394. pg_dump: finding the columns and types of table "x.rhino_2018061312_to_2018061318"
  395. pg_dump: finding check constraints for table "x.rhino_2018061312_to_2018061318"
  396. pg_dump: finding the columns and types of table "x.rhino_2018061318_to_2018061400"
  397. pg_dump: finding check constraints for table "x.rhino_2018061318_to_2018061400"
  398. pg_dump: finding the columns and types of table "x.iguana_2018061400_to_2018061406"
  399. pg_dump: finding check constraints for table "x.iguana_2018061400_to_2018061406"
  400. pg_dump: finding the columns and types of table "x.rhino_2018061400_to_2018061406"
  401. pg_dump: finding check constraints for table "x.rhino_2018061400_to_2018061406"
  402. pg_dump: finding the columns and types of table "x.iguana_2018061406_to_2018061412"
  403. pg_dump: finding check constraints for table "x.iguana_2018061406_to_2018061412"
  404. pg_dump: finding the columns and types of table "x.rhino_2018061406_to_2018061412"
  405. pg_dump: finding check constraints for table "x.rhino_2018061406_to_2018061412"
  406. pg_dump: finding the columns and types of table "x.iguana_2018061412_to_2018061418"
  407. pg_dump: finding check constraints for table "x.iguana_2018061412_to_2018061418"
  408. pg_dump: finding the columns and types of table "x.rhino_2018061412_to_2018061418"
  409. pg_dump: finding check constraints for table "x.rhino_2018061412_to_2018061418"
  410. pg_dump: finding the columns and types of table "x.iguana_2018061418_to_2018061500"
  411. pg_dump: finding check constraints for table "x.iguana_2018061418_to_2018061500"
  412. pg_dump: finding the columns and types of table "x.rhino_2018061418_to_2018061500"
  413. pg_dump: finding check constraints for table "x.rhino_2018061418_to_2018061500"
  414. pg_dump: finding the columns and types of table "x.matview3_000024"
  415. pg_dump: finding the columns and types of table "x.matview3_000168"
  416. pg_dump: finding the columns and types of table "x.matview3_087660"
  417. pg_dump: finding the columns and types of table "x.iguana_2018061500_to_2018061506"
  418. pg_dump: finding check constraints for table "x.iguana_2018061500_to_2018061506"
  419. pg_dump: finding the columns and types of table "x.rhino_2018061500_to_2018061506"
  420. pg_dump: finding check constraints for table "x.rhino_2018061500_to_2018061506"
  421. pg_dump: finding the columns and types of table "x.iguana_2018061506_to_2018061512"
  422. pg_dump: finding check constraints for table "x.iguana_2018061506_to_2018061512"
  423. pg_dump: finding the columns and types of table "x.rhino_2018061506_to_2018061512"
  424. pg_dump: finding check constraints for table "x.rhino_2018061506_to_2018061512"
  425. pg_dump: finding the columns and types of table "x.iguana_2018061512_to_2018061518"
  426. pg_dump: finding check constraints for table "x.iguana_2018061512_to_2018061518"
  427. pg_dump: finding the columns and types of table "x.rhino_2018061512_to_2018061518"
  428. pg_dump: finding check constraints for table "x.rhino_2018061512_to_2018061518"
  429. pg_dump: finding the columns and types of table "x.iguana_2018061518_to_2018061600"
  430. pg_dump: finding check constraints for table "x.iguana_2018061518_to_2018061600"
  431. pg_dump: finding the columns and types of table "x.rhino_2018061518_to_2018061600"
  432. pg_dump: finding check constraints for table "x.rhino_2018061518_to_2018061600"
  433. pg_dump: finding the columns and types of table "x.iguana_2018061600_to_2018061606"
  434. pg_dump: finding check constraints for table "x.iguana_2018061600_to_2018061606"
  435. pg_dump: finding the columns and types of table "x.rhino_2018061600_to_2018061606"
  436. pg_dump: finding check constraints for table "x.rhino_2018061600_to_2018061606"
  437. pg_dump: finding the columns and types of table "x.iguana_2018061606_to_2018061612"
  438. pg_dump: finding check constraints for table "x.iguana_2018061606_to_2018061612"
  439. pg_dump: finding the columns and types of table "x.rhino_2018061606_to_2018061612"
  440. pg_dump: finding check constraints for table "x.rhino_2018061606_to_2018061612"
  441. pg_dump: finding the columns and types of table "x.iguana_2018061612_to_2018061618"
  442. pg_dump: finding check constraints for table "x.iguana_2018061612_to_2018061618"
  443. pg_dump: finding the columns and types of table "x.rhino_2018061612_to_2018061618"
  444. pg_dump: finding check constraints for table "x.rhino_2018061612_to_2018061618"
  445. pg_dump: finding the columns and types of table "x.iguana_2018061618_to_2018061700"
  446. pg_dump: finding check constraints for table "x.iguana_2018061618_to_2018061700"
  447. pg_dump: finding the columns and types of table "x.rhino_2018061618_to_2018061700"
  448. pg_dump: finding check constraints for table "x.rhino_2018061618_to_2018061700"
  449. pg_dump: finding the columns and types of table "x.iguana_2018061700_to_2018061706"
  450. pg_dump: finding check constraints for table "x.iguana_2018061700_to_2018061706"
  451. pg_dump: finding the columns and types of table "x.rhino_2018061700_to_2018061706"
  452. pg_dump: finding check constraints for table "x.rhino_2018061700_to_2018061706"
  453. pg_dump: finding the columns and types of table "x.iguana_2018061706_to_2018061712"
  454. pg_dump: finding check constraints for table "x.iguana_2018061706_to_2018061712"
  455. pg_dump: finding the columns and types of table "x.rhino_2018061706_to_2018061712"
  456. pg_dump: finding check constraints for table "x.rhino_2018061706_to_2018061712"
  457. pg_dump: finding the columns and types of table "x.iguana_2018061712_to_2018061718"
  458. pg_dump: finding check constraints for table "x.iguana_2018061712_to_2018061718"
  459. pg_dump: finding the columns and types of table "x.rhino_2018061712_to_2018061718"
  460. pg_dump: finding check constraints for table "x.rhino_2018061712_to_2018061718"
  461. pg_dump: finding the columns and types of table "x.iguana_2018061718_to_2018061800"
  462. pg_dump: finding check constraints for table "x.iguana_2018061718_to_2018061800"
  463. pg_dump: finding the columns and types of table "x.rhino_2018061718_to_2018061800"
  464. pg_dump: finding check constraints for table "x.rhino_2018061718_to_2018061800"
  465. pg_dump: finding the columns and types of table "x.iguana_2018061800_to_2018061806"
  466. pg_dump: finding check constraints for table "x.iguana_2018061800_to_2018061806"
  467. pg_dump: finding the columns and types of table "x.rhino_2018061800_to_2018061806"
  468. pg_dump: finding check constraints for table "x.rhino_2018061800_to_2018061806"
  469. pg_dump: finding the columns and types of table "x.iguana_2018061806_to_2018061812"
  470. pg_dump: finding check constraints for table "x.iguana_2018061806_to_2018061812"
  471. pg_dump: finding the columns and types of table "x.rhino_2018061806_to_2018061812"
  472. pg_dump: finding check constraints for table "x.rhino_2018061806_to_2018061812"
  473. pg_dump: finding the columns and types of table "x.iguana_2018061812_to_2018061818"
  474. pg_dump: finding check constraints for table "x.iguana_2018061812_to_2018061818"
  475. pg_dump: finding the columns and types of table "x.rhino_2018061812_to_2018061818"
  476. pg_dump: finding check constraints for table "x.rhino_2018061812_to_2018061818"
  477. pg_dump: finding the columns and types of table "x.iguana_2018061818_to_2018061900"
  478. pg_dump: finding check constraints for table "x.iguana_2018061818_to_2018061900"
  479. pg_dump: finding the columns and types of table "x.rhino_2018061818_to_2018061900"
  480. pg_dump: finding check constraints for table "x.rhino_2018061818_to_2018061900"
  481. pg_dump: finding the columns and types of table "x.iguana_2018061900_to_2018061906"
  482. pg_dump: finding check constraints for table "x.iguana_2018061900_to_2018061906"
  483. pg_dump: finding the columns and types of table "x.rhino_2018061900_to_2018061906"
  484. pg_dump: finding check constraints for table "x.rhino_2018061900_to_2018061906"
  485. pg_dump: finding the columns and types of table "x.iguana_2018061906_to_2018061912"
  486. pg_dump: finding check constraints for table "x.iguana_2018061906_to_2018061912"
  487. pg_dump: finding the columns and types of table "x.rhino_2018061906_to_2018061912"
  488. pg_dump: finding check constraints for table "x.rhino_2018061906_to_2018061912"
  489. pg_dump: finding the columns and types of table "x.iguana_2018061912_to_2018061918"
  490. pg_dump: finding check constraints for table "x.iguana_2018061912_to_2018061918"
  491. pg_dump: finding the columns and types of table "x.rhino_2018061912_to_2018061918"
  492. pg_dump: finding check constraints for table "x.rhino_2018061912_to_2018061918"
  493. pg_dump: finding the columns and types of table "x.iguana_2018061918_to_2018062000"
  494. pg_dump: finding check constraints for table "x.iguana_2018061918_to_2018062000"
  495. pg_dump: finding the columns and types of table "x.rhino_2018061918_to_2018062000"
  496. pg_dump: finding check constraints for table "x.rhino_2018061918_to_2018062000"
  497. pg_dump: finding the columns and types of table "x.iguana_2018062000_to_2018062006"
  498. pg_dump: finding check constraints for table "x.iguana_2018062000_to_2018062006"
  499. pg_dump: finding the columns and types of table "x.rhino_2018062000_to_2018062006"
  500. pg_dump: finding check constraints for table "x.rhino_2018062000_to_2018062006"
  501. pg_dump: finding the columns and types of table "x.iguana_2018062006_to_2018062012"
  502. pg_dump: finding check constraints for table "x.iguana_2018062006_to_2018062012"
  503. pg_dump: finding the columns and types of table "x.rhino_2018062006_to_2018062012"
  504. pg_dump: finding check constraints for table "x.rhino_2018062006_to_2018062012"
  505. pg_dump: finding the columns and types of table "x.iguana_2018062012_to_2018062018"
  506. pg_dump: finding check constraints for table "x.iguana_2018062012_to_2018062018"
  507. pg_dump: finding the columns and types of table "x.rhino_2018062012_to_2018062018"
  508. pg_dump: finding check constraints for table "x.rhino_2018062012_to_2018062018"
  509. pg_dump: finding the columns and types of table "x.iguana_2018062018_to_2018062100"
  510. pg_dump: finding check constraints for table "x.iguana_2018062018_to_2018062100"
  511. pg_dump: finding the columns and types of table "x.rhino_2018062018_to_2018062100"
  512. pg_dump: finding check constraints for table "x.rhino_2018062018_to_2018062100"
  513. pg_dump: finding the columns and types of table "x.iguana_2018062100_to_2018062106"
  514. pg_dump: finding check constraints for table "x.iguana_2018062100_to_2018062106"
  515. pg_dump: finding the columns and types of table "x.rhino_2018062100_to_2018062106"
  516. pg_dump: finding check constraints for table "x.rhino_2018062100_to_2018062106"
  517. pg_dump: finding the columns and types of table "x.iguana_2018062106_to_2018062112"
  518. pg_dump: finding check constraints for table "x.iguana_2018062106_to_2018062112"
  519. pg_dump: finding the columns and types of table "x.rhino_2018062106_to_2018062112"
  520. pg_dump: finding check constraints for table "x.rhino_2018062106_to_2018062112"
  521. pg_dump: finding the columns and types of table "x.iguana_2018062112_to_2018062118"
  522. pg_dump: finding check constraints for table "x.iguana_2018062112_to_2018062118"
  523. pg_dump: finding the columns and types of table "x.rhino_2018062112_to_2018062118"
  524. pg_dump: finding check constraints for table "x.rhino_2018062112_to_2018062118"
  525. pg_dump: finding the columns and types of table "x.iguana_2018062118_to_2018062200"
  526. pg_dump: finding check constraints for table "x.iguana_2018062118_to_2018062200"
  527. pg_dump: finding the columns and types of table "x.rhino_2018062118_to_2018062200"
  528. pg_dump: finding check constraints for table "x.rhino_2018062118_to_2018062200"
  529. pg_dump: finding the columns and types of table "x.iguana_cur"
  530. pg_dump: finding check constraints for table "x.iguana_cur"
  531. pg_dump: [archiver (db)] query failed: ERROR: cache lookup failed for relation 1802959
  532. pg_dump: [archiver (db)] query was: SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal, convalidated FROM pg_catalog.pg_constraint WHERE conrelid = '1802959'::pg_catalog.oid
  533. AND contype = 'c' ORDER BY conname
  534. pg_dumpall: pg_dump failed on database "mydb", exiting
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement