API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 13th, 2017
528
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 38.16 KB | None | 0 0
raw download clone embed print report
  1. $ sudo chef-server-ctl restore ~/chef-backup.tgz
  2. Locating rsync..
  3. /usr/bin/rsync
  4. Expanding tarball: /home/ubuntu/chef-backup.tgz
  5. Restoring Chef Server from backup
  6. Cleaning up any old files
  7. *******************************************************************
  8. * * * * * * * * * * * STOP AND READ * * * * * * * * * *
  9. *******************************************************************
  10. This command will delete *all* local configuration, log, and
  11. variable data associated with Chef Server.
  12.  
  13. You have 60 seconds to hit CTRL-C before configuration,
  14. logs, and local data for this application are permanently
  15. deleted.
  16. *******************************************************************
  17.  
  18. ok: down: bookshelf: 1s, normally up
  19. ok: down: nginx: 0s, normally up
  20. ok: down: oc_bifrost: 0s, normally up
  21. ok: down: oc_id: 0s, normally up
  22. ok: down: opscode-chef-mover: 1449s, normally up
  23. ok: down: opscode-erchef: 0s, normally up
  24. ok: down: opscode-expander: 0s, normally up
  25. ok: down: opscode-solr4: 0s, normally up
  26. ok: down: postgresql: 0s, normally up
  27. ok: down: rabbitmq: 0s, normally up
  28. ok: down: redis_lb: 1s, normally up
  29. bookshelf disabled, not stopping
  30. nginx disabled, not stopping
  31. oc_bifrost disabled, not stopping
  32. oc_id disabled, not stopping
  33. opscode-chef-mover disabled, not stopping
  34. opscode-erchef disabled, not stopping
  35. opscode-expander disabled, not stopping
  36. opscode-solr4 disabled, not stopping
  37. postgresql disabled, not stopping
  38. rabbitmq disabled, not stopping
  39. redis_lb disabled, not stopping
  40. Terminating processes running under application users. This will take a few seconds.
  41. Your config files have been backed up to /root/opscode-cleanse-2017-11-12T06:01.
  42. Restoring the opscode data
  43. Restoring the rabbitmq data
  44. Restoring the opscode-solr4 data
  45. Restoring the redis_lb data
  46. Restoring the postgresql data
  47. Restoring the bookshelf data
  48. Restoring the upgrades data
  49. Reconfiguring the Chef Server
  50. Chef Server Reconfigured!
  51. ok: run: postgresql: (pid 22374) 42s
  52. Importing Database dump
  53. could not change directory to "/tmp/d20171112-19292-3qe67w"
  54. SET
  55. SET
  56. SET
  57. ERROR: role "bifrost" already exists
  58. ALTER ROLE
  59. ERROR: role "bifrost_ro" already exists
  60. ALTER ROLE
  61. ERROR: role "oc_id" already exists
  62. ALTER ROLE
  63. ERROR: role "oc_id_ro" already exists
  64. ALTER ROLE
  65. ERROR: role "opscode-pgsql" already exists
  66. ALTER ROLE
  67. ERROR: role "opscode_chef" already exists
  68. ALTER ROLE
  69. ERROR: role "opscode_chef_ro" already exists
  70. ALTER ROLE
  71. ERROR: database "bifrost" already exists
  72. REVOKE
  73. REVOKE
  74. GRANT
  75. GRANT
  76. GRANT
  77. ERROR: database "oc_id" already exists
  78. REVOKE
  79. REVOKE
  80. GRANT
  81. GRANT
  82. GRANT
  83. ERROR: database "opscode-pgsql" already exists
  84. ERROR: database "opscode_chef" already exists
  85. REVOKE
  86. REVOKE
  87. GRANT
  88. GRANT
  89. GRANT
  90. REVOKE
  91. REVOKE
  92. GRANT
  93. GRANT
  94. You are now connected to database "bifrost" as user "opscode-pgsql".
  95. SET
  96. SET
  97. SET
  98. SET
  99. SET
  100. SET
  101. ERROR: schema "debug" already exists
  102. ALTER SCHEMA
  103. ERROR: schema "sqitch" already exists
  104. ALTER SCHEMA
  105. COMMENT
  106. CREATE EXTENSION
  107. COMMENT
  108. SET
  109. ERROR: type "auth_any_permission" already exists
  110. ALTER TYPE
  111. ERROR: type "auth_permission" already exists
  112. ALTER TYPE
  113. ERROR: type "auth_type" already exists
  114. ALTER TYPE
  115. ERROR: function "actor_has_bulk_permission_on" already exists with same argument types
  116. ALTER FUNCTION
  117. ERROR: function "actor_has_permission_on" already exists with same argument types
  118. ALTER FUNCTION
  119. ERROR: function "actor_id" already exists with same argument types
  120. ALTER FUNCTION
  121. ERROR: function "authz_id_for_type" already exists with same argument types
  122. ALTER FUNCTION
  123. ERROR: function "clear_acl" already exists with same argument types
  124. ALTER FUNCTION
  125. ERROR: function "container_id" already exists with same argument types
  126. ALTER FUNCTION
  127. ERROR: function "create_and_add_permissions" already exists with same argument types
  128. ALTER FUNCTION
  129. ERROR: function "forbid_group_cycles" already exists with same argument types
  130. ALTER FUNCTION
  131. COMMENT
  132. ERROR: function "group_id" already exists with same argument types
  133. ALTER FUNCTION
  134. ERROR: function "groups_for_actor" already exists with same argument types
  135. ALTER FUNCTION
  136. ERROR: function "object_id" already exists with same argument types
  137. ALTER FUNCTION
  138. ERROR: function "update_acl" already exists with same argument types
  139. ALTER FUNCTION
  140. SET
  141. SET
  142. ERROR: relation "auth_actor" already exists
  143. ALTER TABLE
  144. ERROR: relation "auth_group" already exists
  145. ALTER TABLE
  146. ERROR: relation "auth_object" already exists
  147. ALTER TABLE
  148. ERROR: relation "group_actor_relations" already exists
  149. ALTER TABLE
  150. ERROR: relation "group_group_relations" already exists
  151. ALTER TABLE
  152. ERROR: relation "object_acl_actor" already exists
  153. ALTER TABLE
  154. ERROR: relation "object_acl_group" already exists
  155. ALTER TABLE
  156. SET
  157. ERROR: relation "object_acl" already exists
  158. ALTER TABLE
  159. COMMENT
  160. COMMENT
  161. COMMENT
  162. COMMENT
  163. COMMENT
  164. COMMENT
  165. SET
  166. ERROR: relation "actor_acl_actor" already exists
  167. ALTER TABLE
  168. ERROR: relation "actor_acl_group" already exists
  169. ALTER TABLE
  170. ERROR: relation "auth_actor_id_seq" already exists
  171. ALTER TABLE
  172. ALTER SEQUENCE
  173. ERROR: relation "auth_container" already exists
  174. ALTER TABLE
  175. ERROR: relation "auth_container_id_seq" already exists
  176. ALTER TABLE
  177. ALTER SEQUENCE
  178. ERROR: relation "auth_group_id_seq" already exists
  179. ALTER TABLE
  180. ALTER SEQUENCE
  181. ERROR: relation "auth_object_id_seq" already exists
  182. ALTER TABLE
  183. ALTER SEQUENCE
  184. ERROR: relation "container_acl_actor" already exists
  185. ALTER TABLE
  186. ERROR: relation "container_acl_group" already exists
  187. ALTER TABLE
  188. ERROR: relation "group_acl_actor" already exists
  189. ALTER TABLE
  190. ERROR: relation "group_acl_group" already exists
  191. ALTER TABLE
  192. SET
  193. ERROR: relation "changes" already exists
  194. ALTER TABLE
  195. COMMENT
  196. COMMENT
  197. COMMENT
  198. COMMENT
  199. COMMENT
  200. COMMENT
  201. COMMENT
  202. COMMENT
  203. COMMENT
  204. COMMENT
  205. COMMENT
  206. ERROR: relation "dependencies" already exists
  207. ALTER TABLE
  208. COMMENT
  209. COMMENT
  210. COMMENT
  211. COMMENT
  212. COMMENT
  213. ERROR: relation "events" already exists
  214. ALTER TABLE
  215. COMMENT
  216. COMMENT
  217. COMMENT
  218. COMMENT
  219. COMMENT
  220. COMMENT
  221. COMMENT
  222. COMMENT
  223. COMMENT
  224. COMMENT
  225. COMMENT
  226. COMMENT
  227. COMMENT
  228. COMMENT
  229. COMMENT
  230. ERROR: relation "projects" already exists
  231. ALTER TABLE
  232. COMMENT
  233. COMMENT
  234. COMMENT
  235. COMMENT
  236. COMMENT
  237. COMMENT
  238. ERROR: relation "tags" already exists
  239. ALTER TABLE
  240. COMMENT
  241. COMMENT
  242. COMMENT
  243. COMMENT
  244. COMMENT
  245. COMMENT
  246. COMMENT
  247. COMMENT
  248. COMMENT
  249. COMMENT
  250. COMMENT
  251. COMMENT
  252. SET
  253. ALTER TABLE
  254. ALTER TABLE
  255. ALTER TABLE
  256. ALTER TABLE
  257. ERROR: duplicate key value violates unique constraint "actor_acl_actor_pkey"
  258. DETAIL: Key (target, authorizee, permission)=(1, 1, create) already exists.
  259. CONTEXT: COPY actor_acl_actor, line 1
  260. ERROR: duplicate key value violates unique constraint "actor_acl_group_pkey"
  261. DETAIL: Key (target, authorizee, permission)=(2, 1, create) already exists.
  262. CONTEXT: COPY actor_acl_group, line 1
  263. ERROR: duplicate key value violates unique constraint "auth_actor_pkey"
  264. DETAIL: Key (id)=(1) already exists.
  265. CONTEXT: COPY auth_actor, line 1
  266. setval
  267. --------
  268. 1152
  269. (1 row)
  270.  
  271. ERROR: duplicate key value violates unique constraint "auth_container_pkey"
  272. DETAIL: Key (id)=(1) already exists.
  273. CONTEXT: COPY auth_container, line 1
  274. setval
  275. --------
  276. 14
  277. (1 row)
  278.  
  279. ERROR: duplicate key value violates unique constraint "auth_group_pkey"
  280. DETAIL: Key (id)=(1) already exists.
  281. CONTEXT: COPY auth_group, line 1
  282. setval
  283. --------
  284. 12
  285. (1 row)
  286.  
  287. ERROR: duplicate key value violates unique constraint "auth_object_pkey"
  288. DETAIL: Key (id)=(1) already exists.
  289. CONTEXT: COPY auth_object, line 1
  290. setval
  291. --------
  292. 1255
  293. (1 row)
  294.  
  295. ERROR: duplicate key value violates unique constraint "container_acl_actor_pkey"
  296. DETAIL: Key (target, authorizee, permission)=(1, 1, grant) already exists.
  297. CONTEXT: COPY container_acl_actor, line 1
  298. ERROR: duplicate key value violates unique constraint "container_acl_group_pkey"
  299. DETAIL: Key (target, authorizee, permission)=(1, 1, create) already exists.
  300. CONTEXT: COPY container_acl_group, line 1
  301. ERROR: duplicate key value violates unique constraint "group_acl_actor_pkey"
  302. DETAIL: Key (target, authorizee, permission)=(1, 1, create) already exists.
  303. CONTEXT: COPY group_acl_actor, line 1
  304. ERROR: duplicate key value violates unique constraint "group_acl_group_pkey"
  305. DETAIL: Key (target, authorizee, permission)=(1, 1, read) already exists.
  306. CONTEXT: COPY group_acl_group, line 1
  307. ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
  308. DETAIL: Key (parent, child)=(1, 1) already exists.
  309. CONTEXT: COPY group_actor_relations, line 1
  310. ERROR: duplicate key value violates unique constraint "group_group_relations_pkey"
  311. DETAIL: Key (parent, child)=(7, 2) already exists.
  312. CONTEXT: COPY group_group_relations, line 1
  313. ERROR: duplicate key value violates unique constraint "object_acl_actor_pkey"
  314. DETAIL: Key (target, authorizee, permission)=(11, 2, create) already exists.
  315. CONTEXT: COPY object_acl_actor, line 1
  316. ERROR: duplicate key value violates unique constraint "object_acl_group_pkey"
  317. DETAIL: Key (target, authorizee, permission)=(1, 2, create) already exists.
  318. CONTEXT: COPY object_acl_group, line 1
  319. SET
  320. ERROR: duplicate key value violates unique constraint "changes_pkey"
  321. DETAIL: Key (change_id)=(fef8546dd4150418c47c16e89da6d492ba42e1b1) already exists.
  322. CONTEXT: COPY changes, line 1
  323. ERROR: duplicate key value violates unique constraint "dependencies_pkey"
  324. DETAIL: Key (change_id, dependency)=(6b5d3fc7f7a2bcc8e5918de743afac742f5ef561, base) already exists.
  325. CONTEXT: COPY dependencies, line 1
  326. ERROR: duplicate key value violates unique constraint "events_pkey"
  327. DETAIL: Key (change_id, committed_at)=(fef8546dd4150418c47c16e89da6d492ba42e1b1, 2017-06-23 04:13:19.87995+00) already exists.
  328. CONTEXT: COPY events, line 1
  329. ERROR: duplicate key value violates unique constraint "projects_pkey"
  330. DETAIL: Key (project)=(bifrost) already exists.
  331. CONTEXT: COPY projects, line 1
  332. ERROR: duplicate key value violates unique constraint "tags_pkey"
  333. DETAIL: Key (tag_id)=(08f76487e22891add26225185cd415a582914284) already exists.
  334. CONTEXT: COPY tags, line 1
  335. SET
  336. ERROR: multiple primary keys for table "actor_acl_actor" are not allowed
  337. ERROR: multiple primary keys for table "actor_acl_group" are not allowed
  338. ERROR: relation "auth_actor_authz_id_key" already exists
  339. ERROR: multiple primary keys for table "auth_actor" are not allowed
  340. ERROR: relation "auth_container_authz_id_key" already exists
  341. ERROR: multiple primary keys for table "auth_container" are not allowed
  342. ERROR: relation "auth_group_authz_id_key" already exists
  343. ERROR: multiple primary keys for table "auth_group" are not allowed
  344. ERROR: relation "auth_object_authz_id_key" already exists
  345. ERROR: multiple primary keys for table "auth_object" are not allowed
  346. ERROR: multiple primary keys for table "container_acl_actor" are not allowed
  347. ERROR: multiple primary keys for table "container_acl_group" are not allowed
  348. ERROR: multiple primary keys for table "group_acl_actor" are not allowed
  349. ERROR: multiple primary keys for table "group_acl_group" are not allowed
  350. ERROR: multiple primary keys for table "group_actor_relations" are not allowed
  351. ERROR: multiple primary keys for table "group_group_relations" are not allowed
  352. ERROR: multiple primary keys for table "object_acl_actor" are not allowed
  353. ERROR: multiple primary keys for table "object_acl_group" are not allowed
  354. SET
  355. ERROR: multiple primary keys for table "changes" are not allowed
  356. ERROR: multiple primary keys for table "dependencies" are not allowed
  357. ERROR: multiple primary keys for table "events" are not allowed
  358. ERROR: multiple primary keys for table "projects" are not allowed
  359. ERROR: relation "projects_uri_key" already exists
  360. ERROR: multiple primary keys for table "tags" are not allowed
  361. ERROR: relation "tags_project_tag_key" already exists
  362. SET
  363. ERROR: relation "actor_acl_actor_authorizee" already exists
  364. ERROR: relation "actor_acl_group_authorizee" already exists
  365. ERROR: relation "container_acl_actor_authorizee" already exists
  366. ERROR: relation "container_acl_group_authorizee" already exists
  367. ERROR: relation "group_acl_actor_authorizee" already exists
  368. ERROR: relation "group_acl_group_authorizee" already exists
  369. ERROR: relation "group_actor_relations_child" already exists
  370. ERROR: relation "group_group_relations_child" already exists
  371. ERROR: relation "object_acl_actor_authorizee" already exists
  372. ERROR: relation "object_acl_group_authorizee" already exists
  373. ERROR: trigger "no_long_range_cycles" for relation "group_group_relations" already exists
  374. ERROR: constraint "actor_acl_actor_authorizee_fkey" for relation "actor_acl_actor" already exists
  375. ERROR: constraint "actor_acl_actor_target_fkey" for relation "actor_acl_actor" already exists
  376. ERROR: constraint "actor_acl_group_authorizee_fkey" for relation "actor_acl_group" already exists
  377. ERROR: constraint "actor_acl_group_target_fkey" for relation "actor_acl_group" already exists
  378. ERROR: constraint "container_acl_actor_authorizee_fkey" for relation "container_acl_actor" already exists
  379. ERROR: constraint "container_acl_actor_target_fkey" for relation "container_acl_actor" already exists
  380. ERROR: constraint "container_acl_group_authorizee_fkey" for relation "container_acl_group" already exists
  381. ERROR: constraint "container_acl_group_target_fkey" for relation "container_acl_group" already exists
  382. ERROR: constraint "group_acl_actor_authorizee_fkey" for relation "group_acl_actor" already exists
  383. ERROR: constraint "group_acl_actor_target_fkey" for relation "group_acl_actor" already exists
  384. ERROR: constraint "group_acl_group_authorizee_fkey" for relation "group_acl_group" already exists
  385. ERROR: constraint "group_acl_group_target_fkey" for relation "group_acl_group" already exists
  386. ERROR: constraint "group_actor_relations_child_fkey" for relation "group_actor_relations" already exists
  387. ERROR: constraint "group_actor_relations_parent_fkey" for relation "group_actor_relations" already exists
  388. ERROR: constraint "group_group_relations_child_fkey" for relation "group_group_relations" already exists
  389. ERROR: constraint "group_group_relations_parent_fkey" for relation "group_group_relations" already exists
  390. ERROR: constraint "object_acl_actor_authorizee_fkey" for relation "object_acl_actor" already exists
  391. ERROR: constraint "object_acl_actor_target_fkey" for relation "object_acl_actor" already exists
  392. ERROR: constraint "object_acl_group_authorizee_fkey" for relation "object_acl_group" already exists
  393. ERROR: constraint "object_acl_group_target_fkey" for relation "object_acl_group" already exists
  394. SET
  395. ERROR: constraint "changes_project_fkey" for relation "changes" already exists
  396. ERROR: constraint "dependencies_change_id_fkey" for relation "dependencies" already exists
  397. ERROR: constraint "dependencies_dependency_id_fkey" for relation "dependencies" already exists
  398. ERROR: constraint "events_project_fkey" for relation "events" already exists
  399. ERROR: constraint "tags_change_id_fkey" for relation "tags" already exists
  400. ERROR: constraint "tags_project_fkey" for relation "tags" already exists
  401. REVOKE
  402. REVOKE
  403. GRANT
  404. GRANT
  405. SET
  406. REVOKE
  407. REVOKE
  408. GRANT
  409. GRANT
  410. GRANT
  411. GRANT
  412. REVOKE
  413. REVOKE
  414. GRANT
  415. GRANT
  416. GRANT
  417. GRANT
  418. REVOKE
  419. REVOKE
  420. GRANT
  421. GRANT
  422. GRANT
  423. GRANT
  424. REVOKE
  425. REVOKE
  426. GRANT
  427. GRANT
  428. GRANT
  429. GRANT
  430. REVOKE
  431. REVOKE
  432. GRANT
  433. GRANT
  434. GRANT
  435. GRANT
  436. REVOKE
  437. REVOKE
  438. GRANT
  439. GRANT
  440. GRANT
  441. GRANT
  442. REVOKE
  443. REVOKE
  444. GRANT
  445. GRANT
  446. GRANT
  447. GRANT
  448. REVOKE
  449. REVOKE
  450. GRANT
  451. GRANT
  452. GRANT
  453. GRANT
  454. REVOKE
  455. REVOKE
  456. GRANT
  457. GRANT
  458. GRANT
  459. GRANT
  460. REVOKE
  461. REVOKE
  462. GRANT
  463. GRANT
  464. GRANT
  465. GRANT
  466. REVOKE
  467. REVOKE
  468. GRANT
  469. GRANT
  470. GRANT
  471. GRANT
  472. REVOKE
  473. REVOKE
  474. GRANT
  475. GRANT
  476. GRANT
  477. GRANT
  478. REVOKE
  479. REVOKE
  480. GRANT
  481. GRANT
  482. GRANT
  483. REVOKE
  484. REVOKE
  485. GRANT
  486. GRANT
  487. GRANT
  488. REVOKE
  489. REVOKE
  490. GRANT
  491. GRANT
  492. GRANT
  493. REVOKE
  494. REVOKE
  495. GRANT
  496. GRANT
  497. GRANT
  498. REVOKE
  499. REVOKE
  500. GRANT
  501. GRANT
  502. GRANT
  503. REVOKE
  504. REVOKE
  505. GRANT
  506. GRANT
  507. GRANT
  508. REVOKE
  509. REVOKE
  510. GRANT
  511. GRANT
  512. GRANT
  513. REVOKE
  514. REVOKE
  515. GRANT
  516. GRANT
  517. GRANT
  518. REVOKE
  519. REVOKE
  520. GRANT
  521. GRANT
  522. GRANT
  523. REVOKE
  524. REVOKE
  525. GRANT
  526. GRANT
  527. GRANT
  528. REVOKE
  529. REVOKE
  530. GRANT
  531. GRANT
  532. GRANT
  533. REVOKE
  534. REVOKE
  535. GRANT
  536. GRANT
  537. GRANT
  538. REVOKE
  539. REVOKE
  540. GRANT
  541. GRANT
  542. GRANT
  543. REVOKE
  544. REVOKE
  545. GRANT
  546. GRANT
  547. GRANT
  548. REVOKE
  549. REVOKE
  550. GRANT
  551. GRANT
  552. GRANT
  553. REVOKE
  554. REVOKE
  555. GRANT
  556. GRANT
  557. GRANT
  558. REVOKE
  559. REVOKE
  560. GRANT
  561. GRANT
  562. GRANT
  563. REVOKE
  564. REVOKE
  565. GRANT
  566. GRANT
  567. GRANT
  568. ALTER DEFAULT PRIVILEGES
  569. ALTER DEFAULT PRIVILEGES
  570. ALTER DEFAULT PRIVILEGES
  571. ALTER DEFAULT PRIVILEGES
  572. ALTER DEFAULT PRIVILEGES
  573. ALTER DEFAULT PRIVILEGES
  574. ALTER DEFAULT PRIVILEGES
  575. ALTER DEFAULT PRIVILEGES
  576. ALTER DEFAULT PRIVILEGES
  577. ALTER DEFAULT PRIVILEGES
  578. ALTER DEFAULT PRIVILEGES
  579. ALTER DEFAULT PRIVILEGES
  580. You are now connected to database "oc_id" as user "opscode-pgsql".
  581. SET
  582. SET
  583. SET
  584. SET
  585. SET
  586. SET
  587. CREATE EXTENSION
  588. COMMENT
  589. SET
  590. SET
  591. SET
  592. ERROR: relation "oauth_access_grants" already exists
  593. ALTER TABLE
  594. ERROR: relation "oauth_access_grants_id_seq" already exists
  595. ALTER TABLE
  596. ALTER SEQUENCE
  597. ERROR: relation "oauth_access_tokens" already exists
  598. ERROR: relation "oauth_access_tokens_id_seq" already exists
  599. ALTER TABLE
  600. ALTER TABLE
  601. ALTER SEQUENCE
  602. ERROR: relation "oauth_applications" already exists
  603. ALTER TABLE
  604. ERROR: relation "oauth_applications_id_seq" already exists
  605. ALTER TABLE
  606. ALTER SEQUENCE
  607. ERROR: relation "schema_migrations" already exists
  608. ALTER TABLE
  609. ALTER TABLE
  610. ALTER TABLE
  611. ALTER TABLE
  612. setval
  613. --------
  614. 1
  615. (1 row)
  616.  
  617. setval
  618. --------
  619. 1
  620. (1 row)
  621.  
  622. setval
  623. --------
  624. 1
  625. (1 row)
  626.  
  627. ERROR: duplicate key value violates unique constraint "unique_schema_migrations"
  628. DETAIL: Key (version)=(20140308061639) already exists.
  629. CONTEXT: COPY schema_migrations, line 1
  630. ERROR: multiple primary keys for table "oauth_access_grants" are not allowed
  631. ERROR: multiple primary keys for table "oauth_access_tokens" are not allowed
  632. ERROR: multiple primary keys for table "oauth_applications" are not allowed
  633. ERROR: relation "index_oauth_access_grants_on_token" already exists
  634. ERROR: relation "index_oauth_access_tokens_on_refresh_token" already exists
  635. ERROR: relation "index_oauth_access_tokens_on_resource_owner_id" already exists
  636. ERROR: relation "index_oauth_access_tokens_on_token" already exists
  637. ERROR: relation "index_oauth_applications_on_uid" already exists
  638. ERROR: relation "unique_schema_migrations" already exists
  639. REVOKE
  640. REVOKE
  641. GRANT
  642. GRANT
  643. REVOKE
  644. REVOKE
  645. GRANT
  646. GRANT
  647. REVOKE
  648. REVOKE
  649. GRANT
  650. GRANT
  651. REVOKE
  652. REVOKE
  653. GRANT
  654. GRANT
  655. REVOKE
  656. REVOKE
  657. GRANT
  658. GRANT
  659. REVOKE
  660. REVOKE
  661. GRANT
  662. GRANT
  663. REVOKE
  664. REVOKE
  665. GRANT
  666. GRANT
  667. REVOKE
  668. REVOKE
  669. GRANT
  670. GRANT
  671. ALTER DEFAULT PRIVILEGES
  672. ALTER DEFAULT PRIVILEGES
  673. ALTER DEFAULT PRIVILEGES
  674. ALTER DEFAULT PRIVILEGES
  675. ALTER DEFAULT PRIVILEGES
  676. ALTER DEFAULT PRIVILEGES
  677. ALTER DEFAULT PRIVILEGES
  678. ALTER DEFAULT PRIVILEGES
  679. ALTER DEFAULT PRIVILEGES
  680. You are now connected to database "opscode-pgsql" as user "opscode-pgsql".
  681. SET
  682. SET
  683. SET
  684. SET
  685. SET
  686. SET
  687. CREATE EXTENSION
  688. COMMENT
  689. REVOKE
  690. REVOKE
  691. GRANT
  692. GRANT
  693. You are now connected to database "opscode_chef" as user "opscode-pgsql".
  694. SET
  695. SET
  696. SET
  697. SET
  698. SET
  699. SET
  700. ERROR: schema "sqitch" already exists
  701. ALTER SCHEMA
  702. COMMENT
  703. CREATE EXTENSION
  704. COMMENT
  705. SET
  706. ERROR: type "cbv" already exists
  707. ALTER TYPE
  708. ERROR: type "org_state" already exists
  709. ALTER TYPE
  710. ERROR: type "password_hash_type" already exists
  711. ALTER TYPE
  712. ERROR: function "add_key" already exists with same argument types
  713. ALTER FUNCTION
  714. ERROR: function "delete_cookbook_artifact_version" already exists with same argument types
  715. ALTER FUNCTION
  716. ERROR: function "delete_keys" already exists with same argument types
  717. ALTER FUNCTION
  718. ERROR: function "delete_migrated_couch_data" already exists with same argument types
  719. ALTER FUNCTION
  720. SET
  721. SET
  722. ERROR: relation "cookbook_artifact_versions" already exists
  723. ALTER TABLE
  724. ALTER TABLE
  725. ALTER TABLE
  726. ERROR: function "insert_cookbook_artifact_version" already exists with same argument types
  727. ALTER FUNCTION
  728. ERROR: function "migrate_keys" already exists with same argument types
  729. ALTER FUNCTION
  730. ERROR: function "update_key" already exists with same argument types
  731. ALTER FUNCTION
  732. ERROR: relation "checksums" already exists
  733. ALTER TABLE
  734. ERROR: relation "clients" already exists
  735. ALTER TABLE
  736. ERROR: relation "containers" already exists
  737. ALTER TABLE
  738. ERROR: relation "cookbook_artifact_version_checksums" already exists
  739. ALTER TABLE
  740. ERROR: relation "cookbook_artifact_versions_id_seq" already exists
  741. ALTER TABLE
  742. ALTER SEQUENCE
  743. ERROR: relation "cookbook_artifacts" already exists
  744. ALTER TABLE
  745. ERROR: relation "cookbook_artifacts_id_seq" already exists
  746. ALTER TABLE
  747. ALTER SEQUENCE
  748. ERROR: relation "cookbook_version_checksums" already exists
  749. ALTER TABLE
  750. ERROR: relation "cookbook_versions" already exists
  751. ALTER TABLE
  752. ALTER TABLE
  753. ALTER TABLE
  754. ALTER TABLE
  755. ALTER TABLE
  756. ERROR: relation "cookbooks" already exists
  757. ALTER TABLE
  758. ERROR: relation "cookbook_version_dependencies" already exists
  759. ALTER TABLE
  760. ERROR: relation "cookbook_versions_by_rank" already exists
  761. ALTER TABLE
  762. ERROR: relation "cookbooks_id_seq" already exists
  763. ALTER TABLE
  764. ALTER SEQUENCE
  765. ERROR: relation "data_bag_items" already exists
  766. ALTER TABLE
  767. ALTER TABLE
  768. ERROR: relation "data_bags" already exists
  769. ALTER TABLE
  770. ERROR: relation "environments" already exists
  771. ALTER TABLE
  772. ALTER TABLE
  773. ERROR: relation "groups" already exists
  774. ALTER TABLE
  775. ERROR: relation "joined_cookbook_version" already exists
  776. ALTER TABLE
  777. ERROR: relation "keys" already exists
  778. ALTER TABLE
  779. ERROR: relation "users" already exists
  780. ALTER TABLE
  781. ERROR: relation "keys_by_name" already exists
  782. ALTER TABLE
  783. ERROR: relation "node_policy" already exists
  784. ALTER TABLE
  785. ERROR: relation "nodes" already exists
  786. ALTER TABLE
  787. ALTER TABLE
  788. ERROR: relation "opc_customers" already exists
  789. ALTER TABLE
  790. ERROR: relation "opc_customers_id_seq" already exists
  791. ALTER TABLE
  792. ALTER SEQUENCE
  793. ERROR: relation "opc_users" already exists
  794. ALTER TABLE
  795. ERROR: relation "org_migration_state" already exists
  796. ALTER TABLE
  797. ERROR: relation "org_migration_state_id_seq" already exists
  798. ALTER TABLE
  799. ALTER SEQUENCE
  800. ERROR: relation "org_user_associations" already exists
  801. ALTER TABLE
  802. ERROR: relation "org_user_invites" already exists
  803. ALTER TABLE
  804. ERROR: relation "orgs" already exists
  805. ALTER TABLE
  806. ERROR: relation "policies" already exists
  807. ALTER TABLE
  808. ERROR: relation "policy_groups" already exists
  809. ALTER TABLE
  810. ALTER TABLE
  811. ERROR: relation "policy_revisions" already exists
  812. ERROR: relation "policy_revisions_policy_groups_association" already exists
  813. ALTER TABLE
  814. ERROR: relation "roles" already exists
  815. ALTER TABLE
  816. ALTER TABLE
  817. ERROR: relation "sandboxed_checksums" already exists
  818. ALTER TABLE
  819. SET
  820. ERROR: relation "changes" already exists
  821. ALTER TABLE
  822. COMMENT
  823. COMMENT
  824. COMMENT
  825. COMMENT
  826. COMMENT
  827. COMMENT
  828. COMMENT
  829. COMMENT
  830. COMMENT
  831. COMMENT
  832. COMMENT
  833. ERROR: relation "dependencies" already exists
  834. ALTER TABLE
  835. COMMENT
  836. COMMENT
  837. COMMENT
  838. COMMENT
  839. COMMENT
  840. ERROR: relation "events" already exists
  841. ALTER TABLE
  842. COMMENT
  843. COMMENT
  844. COMMENT
  845. COMMENT
  846. COMMENT
  847. COMMENT
  848. COMMENT
  849. COMMENT
  850. COMMENT
  851. COMMENT
  852. COMMENT
  853. COMMENT
  854. COMMENT
  855. COMMENT
  856. COMMENT
  857. ERROR: relation "projects" already exists
  858. ALTER TABLE
  859. COMMENT
  860. COMMENT
  861. COMMENT
  862. COMMENT
  863. COMMENT
  864. COMMENT
  865. ERROR: relation "tags" already exists
  866. ALTER TABLE
  867. COMMENT
  868. COMMENT
  869. COMMENT
  870. COMMENT
  871. COMMENT
  872. COMMENT
  873. COMMENT
  874. COMMENT
  875. COMMENT
  876. COMMENT
  877. COMMENT
  878. COMMENT
  879. SET
  880. ALTER TABLE
  881. ALTER TABLE
  882. ALTER TABLE
  883. ALTER TABLE
  884. ALTER TABLE
  885. ERROR: duplicate key value violates unique constraint "checksums_pkey"
  886. DETAIL: Key (org_id, checksum)=(179b46cf76148bf74139019645643fb4, 2130392e5c7ec328f1c80457b9beb025) already exists.
  887. CONTEXT: COPY checksums, line 1
  888. ERROR: duplicate key value violates unique constraint "clients_authz_id_key"
  889. DETAIL: Key (authz_id)=(42df71ee0feed70ab620e4188ffa0491) already exists.
  890. CONTEXT: COPY clients, line 1
  891. ERROR: duplicate key value violates unique constraint "containers_pkey"
  892. DETAIL: Key (id)=(0dfa0de20095d34461c189888bdda7cd) already exists.
  893. CONTEXT: COPY containers, line 1
  894. setval
  895. --------
  896. 1
  897. (1 row)
  898.  
  899. setval
  900. --------
  901. 1
  902. (1 row)
  903.  
  904. ERROR: duplicate key value violates unique constraint "cookbook_versions_pkey"
  905. DETAIL: Key (id)=(019645643fb49359d104505998044da3) already exists.
  906. CONTEXT: COPY cookbook_versions, line 1
  907. ERROR: duplicate key value violates unique constraint "cookbooks_pkey"
  908. DETAIL: Key (id)=(2) already exists.
  909. CONTEXT: COPY cookbooks, line 1
  910. setval
  911. --------
  912. 13
  913. (1 row)
  914.  
  915. ERROR: duplicate key value violates unique constraint "environments_authz_id_key"
  916. DETAIL: Key (authz_id)=(c8dc2d89157e66cc63bf3fce4ed73777) already exists.
  917. CONTEXT: COPY environments, line 1
  918. ERROR: duplicate key value violates unique constraint "groups_pkey"
  919. DETAIL: Key (id)=(8b0806cf0575465691c4508b8433f198) already exists.
  920. CONTEXT: COPY groups, line 1
  921. ERROR: duplicate key value violates unique constraint "keys_pkey"
  922. DETAIL: Key (id, key_name)=(bcbac10b852b4822a20d0c384030da55, default) already exists.
  923. CONTEXT: COPY keys, line 1
  924. ERROR: duplicate key value violates unique constraint "nodes_pkey"
  925. DETAIL: Key (id)=(019645643fb4c95fd48cae371c37a963) already exists.
  926. CONTEXT: COPY nodes, line 1
  927. setval
  928. --------
  929. 1
  930. (1 row)
  931.  
  932. setval
  933. --------
  934. 1
  935. (1 row)
  936.  
  937. ERROR: duplicate key value violates unique constraint "org_user_associations_pkey"
  938. DETAIL: Key (org_id, user_id)=(179b46cf76148bf74139019645643fb4, 000000000000504c8478a06d464b09fc) already exists.
  939. CONTEXT: COPY org_user_associations, line 1
  940. ERROR: duplicate key value violates unique constraint "orgs_pkey"
  941. DETAIL: Key (id)=(179b46cf76148bf74139019645643fb4) already exists.
  942. CONTEXT: COPY orgs, line 1
  943. ERROR: duplicate key value violates unique constraint "roles_authz_id_key"
  944. DETAIL: Key (authz_id)=(7a5d234ee9c215c3be4431a77bac2c73) already exists.
  945. CONTEXT: COPY roles, line 1
  946. ERROR: duplicate key value violates unique constraint "users_pkey"
  947. DETAIL: Key (id)=(bcbac10b852b4822a20d0c384030da55) already exists.
  948. CONTEXT: COPY users, line 1
  949. SET
  950. ERROR: duplicate key value violates unique constraint "changes_pkey"
  951. DETAIL: Key (change_id)=(1f3b7d8c34f96886fb5b04c938b4c4f561ebc450) already exists.
  952. CONTEXT: COPY changes, line 1
  953. ERROR: duplicate key value violates unique constraint "dependencies_pkey"
  954. DETAIL: Key (change_id, dependency)=(d2bd21059104f461d3a62c6c9e4e74c2b97aec19, data_bags) already exists.
  955. CONTEXT: COPY dependencies, line 1
  956. ERROR: duplicate key value violates unique constraint "events_pkey"
  957. DETAIL: Key (change_id, committed_at)=(1f3b7d8c34f96886fb5b04c938b4c4f561ebc450, 2017-06-23 04:13:16.579612+00) already exists.
  958. CONTEXT: COPY events, line 1
  959. ERROR: duplicate key value violates unique constraint "projects_pkey"
  960. DETAIL: Key (project)=(oss_chef) already exists.
  961. CONTEXT: COPY projects, line 1
  962. ERROR: duplicate key value violates unique constraint "tags_pkey"
  963. DETAIL: Key (tag_id)=(9bab840e4c8111e31751e5e14feffb7ea26b86ef) already exists.
  964. CONTEXT: COPY tags, line 1
  965. SET
  966. ERROR: multiple primary keys for table "checksums" are not allowed
  967. ERROR: relation "clients_authz_id_key" already exists
  968. ERROR: multiple primary keys for table "clients" are not allowed
  969. ERROR: relation "containers_authz_id_key" already exists
  970. ERROR: relation "containers_org_id_name_key" already exists
  971. ERROR: multiple primary keys for table "containers" are not allowed
  972. ERROR: relation "cookbook_artifact_versions_cookbook_artifact_id_identifier_key" already exists
  973. ERROR: multiple primary keys for table "cookbook_artifact_versions" are not allowed
  974. ERROR: relation "cookbook_artifacts_authz_id_key" already exists
  975. ERROR: relation "cookbook_artifacts_org_id_name_key" already exists
  976. ERROR: multiple primary keys for table "cookbook_artifacts" are not allowed
  977. ERROR: relation "cookbook_versions_cookbook_id_major_minor_patch_key" already exists
  978. ERROR: multiple primary keys for table "cookbook_versions" are not allowed
  979. ERROR: relation "cookbooks_authz_id_key" already exists
  980. ERROR: relation "cookbooks_org_id_name_key" already exists
  981. ERROR: multiple primary keys for table "cookbooks" are not allowed
  982. ERROR: relation "data_bag_items_org_id_data_bag_name_item_name_key" already exists
  983. ERROR: multiple primary keys for table "data_bag_items" are not allowed
  984. ERROR: relation "data_bags_authz_id_key" already exists
  985. ERROR: relation "data_bags_org_id_name_key" already exists
  986. ERROR: multiple primary keys for table "data_bags" are not allowed
  987. ERROR: relation "environments_authz_id_key" already exists
  988. ERROR: relation "environments_org_id_name_key" already exists
  989. ERROR: multiple primary keys for table "environments" are not allowed
  990. ERROR: relation "groups_authz_id_key" already exists
  991. ERROR: relation "groups_org_id_name_key" already exists
  992. ERROR: multiple primary keys for table "groups" are not allowed
  993. ERROR: multiple primary keys for table "keys" are not allowed
  994. ERROR: relation "nodes_authz_id_key" already exists
  995. ERROR: relation "nodes_org_id_name_key" already exists
  996. ERROR: multiple primary keys for table "nodes" are not allowed
  997. ERROR: relation "opc_customers_domain_key" already exists
  998. ERROR: relation "opc_customers_name_key" already exists
  999. ERROR: multiple primary keys for table "opc_customers" are not allowed
  1000. ERROR: relation "opc_users_user_id_customer_id_key" already exists
  1001. ERROR: relation "org_id_name_unique" already exists
  1002. ERROR: multiple primary keys for table "org_migration_state" are not allowed
  1003. ERROR: multiple primary keys for table "org_user_associations" are not allowed
  1004. ERROR: multiple primary keys for table "org_user_invites" are not allowed
  1005. ERROR: relation "orgs_authz_id_key" already exists
  1006. ERROR: relation "orgs_name_key" already exists
  1007. ERROR: multiple primary keys for table "orgs" are not allowed
  1008. ERROR: relation "policies_authz_id_key" already exists
  1009. ERROR: relation "policies_name_org_id_unique" already exists
  1010. ERROR: relation "policies_org_id_authz_id_name_unique" already exists
  1011. ERROR: multiple primary keys for table "policies" are not allowed
  1012. ERROR: relation "policy_groups_authz_id_key" already exists
  1013. ERROR: relation "policy_groups_org_id_authz_id_name_unique" already exists
  1014. ERROR: relation "policy_groups_org_id_name_unique" already exists
  1015. ERROR: multiple primary keys for table "policy_groups" are not allowed
  1016. ERROR: relation "policy_revisions_org_id_name_revision_id_unique" already exists
  1017. ERROR: multiple primary keys for table "policy_revisions" are not allowed
  1018. ERROR: multiple primary keys for table "policy_revisions_policy_groups_association" are not allowed
  1019. ERROR: relation "prpga_name_group_unique" already exists
  1020. ERROR: relation "roles_authz_id_key" already exists
  1021. ERROR: relation "roles_org_id_name_key" already exists
  1022. ERROR: multiple primary keys for table "roles" are not allowed
  1023. ERROR: multiple primary keys for table "sandboxed_checksums" are not allowed
  1024. ERROR: relation "users_authz_id_key" already exists
  1025. ERROR: relation "users_email_key" already exists
  1026. ERROR: multiple primary keys for table "users" are not allowed
  1027. ERROR: relation "users_username_key" already exists
  1028. SET
  1029. ERROR: multiple primary keys for table "changes" are not allowed
  1030. ERROR: multiple primary keys for table "dependencies" are not allowed
  1031. ERROR: multiple primary keys for table "events" are not allowed
  1032. ERROR: multiple primary keys for table "projects" are not allowed
  1033. ERROR: relation "projects_uri_key" already exists
  1034. ERROR: multiple primary keys for table "tags" are not allowed
  1035. ERROR: relation "tags_project_tag_key" already exists
  1036. SET
  1037. ERROR: relation "cookbook_artifact_version_checksums_by_id" already exists
  1038. ERROR: relation "cookbook_artifact_version_checksums_by_org_id_checksum" already exists
  1039. ERROR: relation "cookbook_artifacts_org_id_index" already exists
  1040. ERROR: relation "cookbook_version_checksums_by_id" already exists
  1041. ERROR: relation "cookbook_version_checksums_by_org_id_checksum" already exists
  1042. ERROR: relation "cookbook_versions_cookbook_id_index" already exists
  1043. ERROR: relation "cookbooks_org_id_index" already exists
  1044. ERROR: relation "nodes_org_id_environment_index" already exists
  1045. ERROR: relation "nodes_policy_group" already exists
  1046. ERROR: relation "nodes_policy_name" already exists
  1047. ERROR: relation "opc_users_customer_id_index" already exists
  1048. ERROR: relation "org_migration_state_name_idx" already exists
  1049. ERROR: relation "org_user_associations_index_user_id_key" already exists
  1050. ERROR: relation "org_user_invites_composite_index_org_id_user_id_key" already exists
  1051. ERROR: relation "org_user_invites_index_user_id_key" already exists
  1052. ERROR: trigger "add_key" for relation "clients" already exists
  1053. ERROR: trigger "add_key" for relation "users" already exists
  1054. ERROR: trigger "delete_keys" for relation "clients" already exists
  1055. ERROR: trigger "delete_keys" for relation "users" already exists
  1056. ERROR: trigger "update_key" for relation "clients" already exists
  1057. ERROR: trigger "update_key" for relation "users" already exists
  1058. ERROR: constraint "cookbook_artifact_version_che_cookbook_artifact_version_id_fkey" for relation "cookbook_artifact_version_checksums" already exists
  1059. ERROR: constraint "cookbook_artifact_version_checksums_org_id_fkey" for relation "cookbook_artifact_version_checksums" already exists
  1060. ERROR: constraint "cookbook_artifact_versions_cookbook_artifact_id_fkey" for relation "cookbook_artifact_versions" already exists
  1061. ERROR: constraint "cookbook_version_checksums_cookbook_version_id_fkey" for relation "cookbook_version_checksums" already exists
  1062. ERROR: constraint "cookbook_version_checksums_org_id_fkey" for relation "cookbook_version_checksums" already exists
  1063. ERROR: constraint "cookbook_versions_cookbook_id_fkey" for relation "cookbook_versions" already exists
  1064. ERROR: constraint "data_bag_items_org_id_fkey" for relation "data_bag_items" already exists
  1065. ERROR: constraint "node_policy_node_id_fkey" for relation "node_policy" already exists
  1066. ERROR: constraint "opc_users_customer_id_fkey" for relation "opc_users" already exists
  1067. ERROR: constraint "opc_users_user_id_fkey" for relation "opc_users" already exists
  1068. ERROR: constraint "org_user_associations_org_id_fkey" for relation "org_user_associations" already exists
  1069. ERROR: constraint "org_user_associations_user_id_fkey" for relation "org_user_associations" already exists
  1070. ERROR: constraint "org_user_invites_org_id_fkey" for relation "org_user_invites" already exists
  1071. ERROR: constraint "org_user_invites_user_id_fkey" for relation "org_user_invites" already exists
  1072. ERROR: constraint "policies_org_id_fkey" for relation "policies" already exists
  1073. ERROR: constraint "policies_org_id_fkey" for relation "policy_groups" already exists
  1074. ERROR: constraint "policy_revisions_org_id_authz_id_policy_name_fkey" for relation "policy_revisions" already exists
  1075. ERROR: constraint "policy_revisions_org_id_fkey" for relation "policy_revisions" already exists
  1076. ERROR: constraint "policy_revisions_org_id_fkey" for relation "policy_revisions_policy_groups_association" already exists
  1077. ERROR: constraint "prpga_association_policy_group_name_fkey" for relation "policy_revisions_policy_groups_association" already exists
  1078. ERROR: constraint "prpga_policy_name_revision_id_fkey" for relation "policy_revisions_policy_groups_association" already exists
  1079. SET
  1080. ERROR: constraint "changes_project_fkey" for relation "changes" already exists
  1081. ERROR: constraint "dependencies_change_id_fkey" for relation "dependencies" already exists
  1082. ERROR: constraint "dependencies_dependency_id_fkey" for relation "dependencies" already exists
  1083. ERROR: constraint "events_project_fkey" for relation "events" already exists
  1084. ERROR: constraint "tags_change_id_fkey" for relation "tags" already exists
  1085. ERROR: constraint "tags_project_fkey" for relation "tags" already exists
  1086. REVOKE
  1087. REVOKE
  1088. GRANT
  1089. GRANT
  1090. SET
  1091. REVOKE
  1092. REVOKE
  1093. GRANT
  1094. GRANT
  1095. GRANT
  1096. GRANT
  1097. REVOKE
  1098. REVOKE
  1099. GRANT
  1100. GRANT
  1101. GRANT
  1102. GRANT
  1103. REVOKE
  1104. REVOKE
  1105. GRANT
  1106. GRANT
  1107. GRANT
  1108. GRANT
  1109. REVOKE
  1110. REVOKE
  1111. GRANT
  1112. GRANT
  1113. GRANT
  1114. GRANT
  1115. REVOKE
  1116. REVOKE
  1117. GRANT
  1118. GRANT
  1119. GRANT
  1120. REVOKE
  1121. REVOKE
  1122. GRANT
  1123. GRANT
  1124. GRANT
  1125. GRANT
  1126. REVOKE
  1127. REVOKE
  1128. GRANT
  1129. GRANT
  1130. GRANT
  1131. GRANT
  1132. REVOKE
  1133. REVOKE
  1134. GRANT
  1135. GRANT
  1136. GRANT
  1137. GRANT
  1138. REVOKE
  1139. REVOKE
  1140. GRANT
  1141. GRANT
  1142. GRANT
  1143. REVOKE
  1144. REVOKE
  1145. GRANT
  1146. GRANT
  1147. GRANT
  1148. REVOKE
  1149. REVOKE
  1150. GRANT
  1151. GRANT
  1152. GRANT
  1153. REVOKE
  1154. REVOKE
  1155. GRANT
  1156. GRANT
  1157. GRANT
  1158. REVOKE
  1159. REVOKE
  1160. GRANT
  1161. GRANT
  1162. GRANT
  1163. REVOKE
  1164. REVOKE
  1165. GRANT
  1166. GRANT
  1167. GRANT
  1168. REVOKE
  1169. REVOKE
  1170. GRANT
  1171. GRANT
  1172. GRANT
  1173. REVOKE
  1174. REVOKE
  1175. GRANT
  1176. GRANT
  1177. GRANT
  1178. REVOKE
  1179. REVOKE
  1180. GRANT
  1181. GRANT
  1182. GRANT
  1183. REVOKE
  1184. REVOKE
  1185. GRANT
  1186. GRANT
  1187. GRANT
  1188. REVOKE
  1189. REVOKE
  1190. GRANT
  1191. GRANT
  1192. GRANT
  1193. REVOKE
  1194. REVOKE
  1195. GRANT
  1196. GRANT
  1197. GRANT
  1198. REVOKE
  1199. REVOKE
  1200. GRANT
  1201. GRANT
  1202. GRANT
  1203. REVOKE
  1204. REVOKE
  1205. GRANT
  1206. GRANT
  1207. GRANT
  1208. REVOKE
  1209. REVOKE
  1210. GRANT
  1211. GRANT
  1212. GRANT
  1213. REVOKE
  1214. REVOKE
  1215. GRANT
  1216. GRANT
  1217. GRANT
  1218. REVOKE
  1219. REVOKE
  1220. GRANT
  1221. GRANT
  1222. GRANT
  1223. REVOKE
  1224. REVOKE
  1225. GRANT
  1226. GRANT
  1227. GRANT
  1228. REVOKE
  1229. REVOKE
  1230. GRANT
  1231. GRANT
  1232. GRANT
  1233. REVOKE
  1234. REVOKE
  1235. GRANT
  1236. GRANT
  1237. GRANT
  1238. REVOKE
  1239. REVOKE
  1240. GRANT
  1241. GRANT
  1242. GRANT
  1243. REVOKE
  1244. REVOKE
  1245. GRANT
  1246. GRANT
  1247. GRANT
  1248. REVOKE
  1249. REVOKE
  1250. GRANT
  1251. GRANT
  1252. GRANT
  1253. REVOKE
  1254. REVOKE
  1255. GRANT
  1256. GRANT
  1257. GRANT
  1258. REVOKE
  1259. REVOKE
  1260. GRANT
  1261. GRANT
  1262. GRANT
  1263. REVOKE
  1264. REVOKE
  1265. GRANT
  1266. GRANT
  1267. GRANT
  1268. REVOKE
  1269. REVOKE
  1270. GRANT
  1271. GRANT
  1272. GRANT
  1273. REVOKE
  1274. REVOKE
  1275. GRANT
  1276. GRANT
  1277. GRANT
  1278. REVOKE
  1279. REVOKE
  1280. GRANT
  1281. GRANT
  1282. GRANT
  1283. REVOKE
  1284. REVOKE
  1285. GRANT
  1286. GRANT
  1287. GRANT
  1288. REVOKE
  1289. REVOKE
  1290. GRANT
  1291. GRANT
  1292. GRANT
  1293. REVOKE
  1294. REVOKE
  1295. GRANT
  1296. GRANT
  1297. GRANT
  1298. REVOKE
  1299. REVOKE
  1300. GRANT
  1301. GRANT
  1302. GRANT
  1303. REVOKE
  1304. REVOKE
  1305. GRANT
  1306. GRANT
  1307. GRANT
  1308. REVOKE
  1309. REVOKE
  1310. GRANT
  1311. GRANT
  1312. GRANT
  1313. REVOKE
  1314. REVOKE
  1315. GRANT
  1316. GRANT
  1317. GRANT
  1318. REVOKE
  1319. REVOKE
  1320. GRANT
  1321. GRANT
  1322. GRANT
  1323. ALTER DEFAULT PRIVILEGES
  1324. ALTER DEFAULT PRIVILEGES
  1325. ALTER DEFAULT PRIVILEGES
  1326. ALTER DEFAULT PRIVILEGES
  1327. ALTER DEFAULT PRIVILEGES
  1328. ALTER DEFAULT PRIVILEGES
  1329. ALTER DEFAULT PRIVILEGES
  1330. ALTER DEFAULT PRIVILEGES
  1331. ALTER DEFAULT PRIVILEGES
  1332. ALTER DEFAULT PRIVILEGES
  1333. ALTER DEFAULT PRIVILEGES
  1334. ALTER DEFAULT PRIVILEGES
  1335. You are now connected to database "postgres" as user "opscode-pgsql".
  1336. SET
  1337. SET
  1338. SET
  1339. SET
  1340. SET
  1341. SET
  1342. COMMENT
  1343. CREATE EXTENSION
  1344. COMMENT
  1345. REVOKE
  1346. REVOKE
  1347. GRANT
  1348. GRANT
  1349. You are now connected to database "template1" as user "opscode-pgsql".
  1350. SET
  1351. SET
  1352. SET
  1353. SET
  1354. SET
  1355. SET
  1356. COMMENT
  1357. CREATE EXTENSION
  1358. COMMENT
  1359. REVOKE
  1360. REVOKE
  1361. GRANT
  1362. GRANT
  1363. Bringing up the Chef Server
  1364. ok: run: bookshelf: (pid 24051) 10s
  1365. ok: run: nginx: (pid 23878) 15s
  1366. ok: run: oc_bifrost: (pid 23791) 18s
  1367. ok: run: oc_id: (pid 23868) 18s
  1368. ok: run: opscode-chef-mover: (pid 22491) 46s
  1369. ok: run: opscode-erchef: (pid 24087) 18s
  1370. ok: run: opscode-expander: (pid 23945) 20s
  1371. ok: run: opscode-solr4: (pid 23914) 23s
  1372. ok: run: postgresql: (pid 22374) 60s
  1373. ok: run: rabbitmq: (pid 23249) 39s
  1374. ok: run: redis_lb: (pid 22888) 55s
  1375. Cleaning up /tmp/chef_backup20171112-19292-1h8u63e
  1376. Restoration Completed!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!