API tools faq
paste
Advertisement
simserver

35 t.-out:su postgres

simserver
May 24th, 2015
219
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 9.77 KB | None | 0 0
raw download clone embed print report
  1. thomas@ViperLinux:~$ cd /var/lib/tomcat6/webapps/simserver/sql
  2. thomas@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ sudo su postgres
  3. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ sudo ./pg_db_script.sh
  4. [sudo] password for postgres:
  5. Sorry, try again.
  6. [sudo] password for postgres:
  7. Sorry, try again.
  8. [sudo] password for postgres:
  9. Sorry, try again.
  10. sudo: 3 incorrect password attempts
  11. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ psql -f  createdb.sql
  12. psql:createdb.sql:3: ERROR:  database "simserver" does not exist
  13. psql:createdb.sql:4: ERROR:  role "simserver" does not exist
  14. CREATE ROLE
  15. CREATE DATABASE
  16. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ psql -h localhost -U simserver  simserver  -f  tables1.sql
  17. Password for user simserver:
  18. psql:tables1.sql:3: NOTICE:  type "gametype" does not exist, skipping
  19. DROP DOMAIN
  20. CREATE DOMAIN
  21. psql:tables1.sql:8: NOTICE:  type "playertype" does not exist, skipping
  22. DROP DOMAIN
  23. CREATE DOMAIN
  24. psql:tables1.sql:13: NOTICE:  type "protocoltype" does not exist, skipping
  25. DROP DOMAIN
  26. CREATE DOMAIN
  27. psql:tables1.sql:19: NOTICE:  table "game" does not exist, skipping
  28. DROP TABLE
  29. CREATE TABLE
  30. psql:tables1.sql:32: NOTICE:  table "player" does not exist, skipping
  31. DROP TABLE
  32. CREATE TABLE
  33. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ psql -h localhost -U simserver  simserver  -f  tables2.sql
  34. Password for user simserver:
  35. psql:tables2.sql:4: NOTICE:  type "prologname" does not exist, skipping
  36. DROP DOMAIN
  37. CREATE DOMAIN
  38. psql:tables2.sql:10: NOTICE:  type "realmtype" does not exist, skipping
  39. DROP DOMAIN
  40. CREATE DOMAIN
  41. psql:tables2.sql:15: NOTICE:  type "positiontype" does not exist, skipping
  42. DROP DOMAIN
  43. CREATE DOMAIN
  44. psql:tables2.sql:21: NOTICE:  table "authrole" does not exist, skipping
  45. DROP TABLE
  46. CREATE TABLE
  47. psql:tables2.sql:30: NOTICE:  table "glstate" does not exist, skipping
  48. DROP TABLE
  49. CREATE TABLE
  50. psql:tables2.sql:36: NOTICE:  table "match" does not exist, skipping
  51. DROP TABLE
  52. psql:tables2.sql:37: NOTICE:  sequence "match_matchid_seq" does not exist, skipping
  53. DROP SEQUENCE
  54. CREATE SEQUENCE
  55. CREATE TABLE
  56. psql:tables2.sql:56: NOTICE:  table "matchplayer" does not exist, skipping
  57. DROP TABLE
  58. CREATE TABLE
  59. psql:tables2.sql:71: NOTICE:  table "matchstate" does not exist, skipping
  60. DROP TABLE
  61. CREATE TABLE
  62. psql:tables2.sql:85: NOTICE:  table "matchview" does not exist, skipping
  63. DROP TABLE
  64. CREATE TABLE
  65. psql:tables2.sql:105: NOTICE:  table "position" does not exist, skipping
  66. DROP TABLE
  67. CREATE TABLE
  68. psql:tables2.sql:123: NOTICE:  table "parameters" does not exist, skipping
  69. DROP TABLE
  70. CREATE TABLE
  71. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ psql -h localhost -U simserver  simserver  -f  views.sql
  72. Password for user simserver:
  73. psql:views.sql:2: NOTICE:  view "player_matchplayer" does not exist, skipping
  74. DROP VIEW
  75. psql:views.sql:3: NOTICE:  view "match_matchviews" does not exist, skipping
  76. DROP VIEW
  77. psql:views.sql:4: NOTICE:  view "partners" does not exist, skipping
  78. DROP VIEW
  79. psql:views.sql:5: NOTICE:  view "waitingmatch" does not exist, skipping
  80. DROP VIEW
  81. psql:views.sql:6: NOTICE:  view "game_match" does not exist, skipping
  82. DROP VIEW
  83. psql:views.sql:7: NOTICE:  view "match_matchstate" does not exist, skipping
  84. DROP VIEW
  85. psql:views.sql:8: NOTICE:  view "userposition" does not exist, skipping
  86. DROP VIEW
  87. psql:views.sql:9: NOTICE:  view "realposition" does not exist, skipping
  88. DROP VIEW
  89. psql:views.sql:10: NOTICE:  view "matchstate_round" does not exist, skipping
  90. DROP VIEW
  91. CREATE VIEW
  92. CREATE VIEW
  93. CREATE VIEW
  94. CREATE VIEW
  95. CREATE VIEW
  96. CREATE VIEW
  97. CREATE VIEW
  98. CREATE VIEW
  99. CREATE VIEW
  100. CREATE VIEW
  101. CREATE VIEW
  102. CREATE VIEW
  103. CREATE VIEW
  104. CREATE VIEW
  105. CREATE VIEW
  106. CREATE VIEW
  107. CREATE VIEW
  108. CREATE VIEW
  109. CREATE VIEW
  110. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ psql -h localhost -U simserver  simserver  -f  data1.sql
  111. Password for user simserver:
  112. DELETE 0
  113. INSERT 0 1
  114. INSERT 0 1
  115. INSERT 0 1
  116. INSERT 0 1
  117. DELETE 0
  118. INSERT 0 1
  119. INSERT 0 1
  120. INSERT 0 1
  121. INSERT 0 1
  122. INSERT 0 1
  123. INSERT 0 1
  124. INSERT 0 1
  125. INSERT 0 1
  126. INSERT 0 1
  127. INSERT 0 1
  128. INSERT 0 1
  129. INSERT 0 1
  130. INSERT 0 1
  131. INSERT 0 1
  132. INSERT 0 1
  133. INSERT 0 1
  134. INSERT 0 1
  135. INSERT 0 1
  136. INSERT 0 1
  137. INSERT 0 1
  138. INSERT 0 1
  139. INSERT 0 1
  140. INSERT 0 1
  141. INSERT 0 1
  142. INSERT 0 1
  143. INSERT 0 1
  144. INSERT 0 1
  145. INSERT 0 1
  146. INSERT 0 1
  147. INSERT 0 1
  148. INSERT 0 1
  149. INSERT 0 1
  150. INSERT 0 1
  151. INSERT 0 1
  152. INSERT 0 1
  153. INSERT 0 1
  154. INSERT 0 1
  155. INSERT 0 1
  156. INSERT 0 1
  157. postgres@ViperLinux:/var/lib/tomcat6/webapps/simserver/sql$ psql -h localhost -U simserver  simserver  -f  data2.sql
  158. Password for user simserver:
  159. DELETE 0
  160. INSERT 0 1
  161. DELETE 0
  162. INSERT 0 1
  163. DELETE 0
  164. INSERT 0 1
  165. INSERT 0 1
  166. INSERT 0 1
  167. INSERT 0 1
  168. INSERT 0 1
  169. INSERT 0 1
  170. INSERT 0 1
  171. INSERT 0 1
  172. INSERT 0 1
  173. INSERT 0 1
  174. INSERT 0 1
  175. INSERT 0 1
  176. INSERT 0 1
  177. INSERT 0 1
  178. INSERT 0 1
  179. INSERT 0 1
  180. INSERT 0 1
  181. INSERT 0 1
  182. INSERT 0 1
  183. INSERT 0 1
  184. INSERT 0 1
  185. INSERT 0 1
  186. INSERT 0 1
  187. INSERT 0 1
  188. INSERT 0 1
  189. INSERT 0 1
  190. INSERT 0 1
  191. INSERT 0 1
  192. INSERT 0 1
  193. INSERT 0 1
  194. INSERT 0 1
  195. INSERT 0 1
  196. INSERT 0 1
  197. INSERT 0 1
  198. INSERT 0 1
  199. INSERT 0 1
  200. INSERT 0 1
  201. INSERT 0 1
  202. INSERT 0 1
  203. INSERT 0 1
  204. INSERT 0 1
  205. INSERT 0 1
  206. INSERT 0 1
  207. INSERT 0 1
  208. INSERT 0 1
  209. INSERT 0 1
  210. INSERT 0 1
  211. INSERT 0 1
  212. INSERT 0 1
  213. INSERT 0 1
  214. INSERT 0 1
  215. INSERT 0 1
  216. INSERT 0 1
  217. INSERT 0 1
  218. INSERT 0 1
  219. INSERT 0 1
  220. INSERT 0 1
  221. INSERT 0 1
  222. INSERT 0 1
  223. INSERT 0 1
  224. INSERT 0 1
  225. INSERT 0 1
  226. INSERT 0 1
  227. INSERT 0 1
  228. INSERT 0 1
  229. INSERT 0 1
  230. INSERT 0 1
  231. INSERT 0 1
  232. INSERT 0 1
  233. INSERT 0 1
  234. INSERT 0 1
  235. INSERT 0 1
  236. INSERT 0 1
  237. INSERT 0 1
  238. INSERT 0 1
  239. INSERT 0 1
  240. INSERT 0 1
  241. INSERT 0 1
  242. INSERT 0 1
  243. INSERT 0 1
  244. INSERT 0 1
  245. INSERT 0 1
  246. INSERT 0 1
  247. INSERT 0 1
  248. INSERT 0 1
  249. INSERT 0 1
  250. INSERT 0 1
  251. INSERT 0 1
  252. INSERT 0 1
  253. INSERT 0 1
  254. INSERT 0 1
  255. INSERT 0 1
  256. INSERT 0 1
  257. INSERT 0 1
  258. INSERT 0 1
  259. INSERT 0 1
  260. INSERT 0 1
  261. INSERT 0 1
  262. INSERT 0 1
  263. INSERT 0 1
  264. INSERT 0 1
  265. INSERT 0 1
  266. INSERT 0 1
  267. INSERT 0 1
  268. INSERT 0 1
  269. INSERT 0 1
  270. INSERT 0 1
  271. INSERT 0 1
  272. INSERT 0 1
  273. INSERT 0 1
  274. INSERT 0 1
  275. INSERT 0 1
  276. INSERT 0 1
  277. INSERT 0 1
  278. INSERT 0 1
  279. INSERT 0 1
  280. INSERT 0 1
  281. INSERT 0 1
  282. INSERT 0 1
  283. INSERT 0 1
  284. INSERT 0 1
  285. INSERT 0 1
  286. INSERT 0 1
  287. INSERT 0 1
  288. INSERT 0 1
  289. INSERT 0 1
  290. INSERT 0 1
  291. INSERT 0 1
  292. INSERT 0 1
  293. INSERT 0 1
  294. INSERT 0 1
  295. INSERT 0 1
  296. INSERT 0 1
  297. INSERT 0 1
  298. INSERT 0 1
  299. INSERT 0 1
  300. INSERT 0 1
  301. INSERT 0 1
  302. INSERT 0 1
  303. INSERT 0 1
  304. INSERT 0 1
  305. INSERT 0 1
  306. INSERT 0 1
  307. INSERT 0 1
  308. INSERT 0 1
  309. INSERT 0 1
  310. INSERT 0 1
  311. INSERT 0 1
  312. INSERT 0 1
  313. INSERT 0 1
  314. INSERT 0 1
  315. INSERT 0 1
  316. INSERT 0 1
  317. INSERT 0 1
  318. INSERT 0 1
  319. INSERT 0 1
  320. INSERT 0 1
  321. INSERT 0 1
  322. INSERT 0 1
  323. INSERT 0 1
  324. INSERT 0 1
  325. INSERT 0 1
  326. INSERT 0 1
  327. INSERT 0 1
  328. INSERT 0 1
  329. INSERT 0 1
  330. INSERT 0 1
  331. INSERT 0 1
  332. INSERT 0 1
  333. INSERT 0 1
  334. INSERT 0 1
  335. INSERT 0 1
  336. INSERT 0 1
  337. INSERT 0 1
  338. INSERT 0 1
  339. INSERT 0 1
  340. INSERT 0 1
  341. INSERT 0 1
  342. INSERT 0 1
  343. INSERT 0 1
  344. INSERT 0 1
  345. INSERT 0 1
  346. INSERT 0 1
  347. INSERT 0 1
  348. INSERT 0 1
  349. INSERT 0 1
  350. INSERT 0 1
  351. INSERT 0 1
  352. INSERT 0 1
  353. INSERT 0 1
  354. INSERT 0 1
  355. INSERT 0 1
  356. INSERT 0 1
  357. INSERT 0 1
  358. INSERT 0 1
  359. INSERT 0 1
  360. INSERT 0 1
  361. INSERT 0 1
  362. INSERT 0 1
  363. INSERT 0 1
  364. INSERT 0 1
  365. INSERT 0 1
  366. INSERT 0 1
  367. INSERT 0 1
  368. INSERT 0 1
  369. INSERT 0 1
  370. INSERT 0 1
  371. INSERT 0 1
  372. INSERT 0 1
  373. INSERT 0 1
  374. INSERT 0 1
  375. INSERT 0 1
  376. INSERT 0 1
  377. INSERT 0 1
  378. INSERT 0 1
  379. INSERT 0 1
  380. INSERT 0 1
  381. INSERT 0 1
  382. INSERT 0 1
  383. INSERT 0 1
  384. INSERT 0 1
  385. INSERT 0 1
  386. INSERT 0 1
  387. INSERT 0 1
  388. INSERT 0 1
  389. INSERT 0 1
  390. INSERT 0 1
  391. INSERT 0 1
  392. INSERT 0 1
  393. INSERT 0 1
  394. INSERT 0 1
  395. INSERT 0 1
  396. INSERT 0 1
  397. INSERT 0 1
  398. INSERT 0 1
  399. INSERT 0 1
  400. INSERT 0 1
  401. INSERT 0 1
  402. INSERT 0 1
  403. INSERT 0 1
  404. INSERT 0 1
  405. INSERT 0 1
  406. INSERT 0 1
  407. INSERT 0 1
  408. INSERT 0 1
  409. INSERT 0 1
  410. INSERT 0 1
  411. INSERT 0 1
  412. INSERT 0 1
  413. INSERT 0 1
  414. INSERT 0 1
  415. INSERT 0 1
  416. INSERT 0 1
  417. INSERT 0 1
  418. INSERT 0 1
  419. INSERT 0 1
  420. INSERT 0 1
  421. INSERT 0 1
  422. INSERT 0 1
  423. INSERT 0 1
  424. INSERT 0 1
  425. INSERT 0 1
  426. INSERT 0 1
  427. INSERT 0 1
  428. INSERT 0 1
  429. INSERT 0 1
  430. INSERT 0 1
  431. INSERT 0 1
  432. INSERT 0 1
  433. INSERT 0 1
  434. INSERT 0 1
  435. INSERT 0 1
  436. INSERT 0 1
  437. INSERT 0 1
  438. INSERT 0 1
  439. INSERT 0 1
  440. INSERT 0 1
  441. INSERT 0 1
  442. INSERT 0 1
  443. INSERT 0 1
  444. INSERT 0 1
  445. INSERT 0 1
  446. INSERT 0 1
  447. INSERT 0 1
  448. INSERT 0 1
  449. INSERT 0 1
  450. INSERT 0 1
  451. INSERT 0 1
  452. INSERT 0 1
  453. INSERT 0 1
  454. INSERT 0 1
  455. INSERT 0 1
  456. INSERT 0 1
  457. INSERT 0 1
  458. INSERT 0 1
  459. INSERT 0 1
  460. INSERT 0 1
  461. INSERT 0 1
  462. INSERT 0 1
  463. INSERT 0 1
  464. INSERT 0 1
  465. INSERT 0 1
  466. INSERT 0 1
  467. INSERT 0 1
  468. INSERT 0 1
  469. INSERT 0 1
  470. INSERT 0 1
  471. INSERT 0 1
  472. INSERT 0 1
  473. INSERT 0 1
  474. INSERT 0 1
  475. INSERT 0 1
  476. INSERT 0 1
  477. INSERT 0 1
  478. INSERT 0 1
  479. INSERT 0 1
  480. INSERT 0 1
  481. INSERT 0 1
  482. INSERT 0 1
  483. INSERT 0 1
  484. INSERT 0 1
  485. INSERT 0 1
  486. INSERT 0 1
  487. INSERT 0 1
  488. INSERT 0 1
  489. INSERT 0 1
  490. INSERT 0 1
  491. INSERT 0 1
  492. INSERT 0 1
  493. INSERT 0 1
  494. INSERT 0 1
  495. INSERT 0 1
  496. INSERT 0 1
  497. INSERT 0 1
  498. INSERT 0 1
  499. INSERT 0 1
  500. INSERT 0 1
  501. INSERT 0 1
  502. INSERT 0 1
  503. INSERT 0 1
  504. INSERT 0 1
  505. INSERT 0 1
  506. INSERT 0 1
  507. INSERT 0 1
  508. INSERT 0 1
  509. INSERT 0 1
  510. INSERT 0 1
  511. INSERT 0 1
  512. INSERT 0 1
  513. INSERT 0 1
  514. INSERT 0 1
  515. INSERT 0 1
  516. INSERT 0 1
  517. INSERT 0 1
  518. INSERT 0 1
  519. INSERT 0 1
  520. INSERT 0 1
  521. INSERT 0 1
  522. INSERT 0 1
  523. INSERT 0 1
  524. INSERT 0 1
  525. INSERT 0 1
  526. INSERT 0 1
  527. INSERT 0 1
  528. INSERT 0 1
  529. INSERT 0 1
  530. INSERT 0 1
  531. INSERT 0 1
  532. INSERT 0 1
  533. INSERT 0 1
  534. INSERT 0 1
  535. INSERT 0 1
  536. INSERT 0 1
  537. INSERT 0 1
  538. INSERT 0 1
  539. INSERT 0 1
  540. INSERT 0 1
  541. INSERT 0 1
  542. INSERT 0 1
  543. INSERT 0 1
  544. INSERT 0 1
  545. INSERT 0 1
  546. INSERT 0 1
  547. INSERT 0 1
  548. INSERT 0 1
  549. INSERT 0 1
  550. INSERT 0 1
  551. INSERT 0 1
  552. INSERT 0 1
  553. INSERT 0 1
  554. INSERT 0 1
  555. INSERT 0 1
  556. INSERT 0 1
  557. INSERT 0 1
  558. INSERT 0 1
  559. INSERT 0 1
  560. INSERT 0 1
  561. INSERT 0 1
  562. INSERT 0 1
  563. INSERT 0 1
  564. INSERT 0 1
  565. INSERT 0 1
  566. INSERT 0 1
  567. INSERT 0 1
  568. INSERT 0 1
  569. INSERT 0 1
  570. INSERT 0 1
  571. INSERT 0 1
  572. INSERT 0 1
  573. INSERT 0 1
  574. INSERT 0 1
  575. INSERT 0 1
  576. INSERT 0 1
  577. INSERT 0 1
  578. INSERT 0 1
  579. INSERT 0 1
  580. INSERT 0 1
  581. INSERT 0 1
  582. INSERT 0 1
  583. INSERT 0 1
  584. INSERT 0 1
  585. INSERT 0 1
  586. INSERT 0 1
  587. INSERT 0 1
  588. INSERT 0 1
  589. INSERT 0 1
  590. INSERT 0 1
  591. INSERT 0 1
  592. INSERT 0 1
  593. INSERT 0 1
  594. INSERT 0 1
  595. INSERT 0 1
  596. INSERT 0 1
  597. INSERT 0 1
  598. INSERT 0 1
  599. INSERT 0 1
  600. INSERT 0 1
  601. INSERT 0 1
  602. INSERT 0 1
  603. INSERT 0 1
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!