API tools faq
paste
Guest User

Untitled

a guest
Jan 16th, 2019
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.89 KB | None | 0 0
raw download clone embed print report
  1. Last login: Tue Jan 15 18:53:53 on ttys000
  2.  
  3. hammad at MacBokuPro2018 in ~
  4. $ cd ~/dev/work/calltime/call-time-app-strapi
  5.  
  6. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  7. $ npm i strapi@alpha -g
  8. npm WARN deprecated joi@10.2.2: This version is no longer maintained. Please upgrade to the latest version.
  9. /usr/local/bin/strapi -> /usr/local/lib/node_modules/strapi/bin/strapi.js
  10. npm WARN react-ga@2.5.6 requires a peer of prop-types@^15.6.0 but none is installed. You must install peer dependencies yourself.
  11. npm WARN react-ga@2.5.6 requires a peer of react@^15.6.2 || ^16.0 but none is installed. You must install peer dependencies yourself.
  12.  
  13. + strapi@3.0.0-alpha.18
  14. added 375 packages from 267 contributors in 19.096s
  15.  
  16. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  17. $ strapi -v
  18. 3.0.0-alpha.18
  19.  
  20. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  21. $ strapi start
  22. internal/modules/cjs/loader.js:605
  23. throw err;
  24. ^
  25.  
  26. Error: Cannot find module 'lodash'
  27. at Function.Module._resolveFilename (internal/modules/cjs/loader.js:603:15)
  28. at Function.Module._load (internal/modules/cjs/loader.js:529:25)
  29. at Module.require (internal/modules/cjs/loader.js:657:17)
  30. at require (internal/modules/cjs/helpers.js:22:18)
  31. at Object.<anonymous> (/Users/hammad/dev/work/calltime/call-time-app-strapi/admin/controllers/Admin.js:5:11)
  32. at Module._compile (internal/modules/cjs/loader.js:721:30)
  33. at Object.Module._extensions..js (internal/modules/cjs/loader.js:732:10)
  34. at Module.load (internal/modules/cjs/loader.js:620:32)
  35. at tryModuleLoad (internal/modules/cjs/loader.js:560:12)
  36. at Function.Module._load (internal/modules/cjs/loader.js:552:3)
  37. ^C
  38.  
  39. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  40. $ open .
  41.  
  42. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  43. $ npm run setup
  44.  
  45. > backend-call-time@0.1.0 setup /Users/hammad/dev/work/calltime/call-time-app-strapi
  46. > cd admin && npm run setup
  47.  
  48.  
  49. > strapi-admin@3.0.0-alpha.14.5 presetup /Users/hammad/dev/work/calltime/call-time-app-strapi/admin
  50. > node ./scripts/preSetup.js
  51.  
  52. internal/modules/cjs/loader.js:605
  53. throw err;
  54. ^
  55.  
  56. Error: Cannot find module 'shelljs'
  57. at Function.Module._resolveFilename (internal/modules/cjs/loader.js:603:15)
  58. at Function.Module._load (internal/modules/cjs/loader.js:529:25)
  59. at Module.require (internal/modules/cjs/loader.js:657:17)
  60. at require (internal/modules/cjs/helpers.js:22:18)
  61. at Object.<anonymous> (/Users/hammad/dev/work/calltime/call-time-app-strapi/admin/scripts/preSetup.js:1:77)
  62. at Module._compile (internal/modules/cjs/loader.js:721:30)
  63. at Object.Module._extensions..js (internal/modules/cjs/loader.js:732:10)
  64. at Module.load (internal/modules/cjs/loader.js:620:32)
  65. at tryModuleLoad (internal/modules/cjs/loader.js:560:12)
  66. at Function.Module._load (internal/modules/cjs/loader.js:552:3)
  67. npm ERR! code ELIFECYCLE
  68. npm ERR! errno 1
  69. npm ERR! strapi-admin@3.0.0-alpha.14.5 presetup: `node ./scripts/preSetup.js`
  70. npm ERR! Exit status 1
  71. npm ERR!
  72. npm ERR! Failed at the strapi-admin@3.0.0-alpha.14.5 presetup script.
  73. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
  74. npm WARN Local package.json exists, but node_modules missing, did you mean to install?
  75.  
  76. npm ERR! A complete log of this run can be found in:
  77. npm ERR! /Users/hammad/.npm/_logs/2019-01-16T00_50_12_850Z-debug.log
  78. npm ERR! code ELIFECYCLE
  79. npm ERR! errno 1
  80. npm ERR! backend-call-time@0.1.0 setup: `cd admin && npm run setup`
  81. npm ERR! Exit status 1
  82. npm ERR!
  83. npm ERR! Failed at the backend-call-time@0.1.0 setup script.
  84. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
  85. npm WARN Local package.json exists, but node_modules missing, did you mean to install?
  86.  
  87. npm ERR! A complete log of this run can be found in:
  88. npm ERR! /Users/hammad/.npm/_logs/2019-01-16T00_50_12_870Z-debug.log
  89.  
  90. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  91. $ psql
  92. psql (11.0)
  93. Type "help" for help.
  94.  
  95. hammad=# help
  96. You are using psql, the command-line interface to PostgreSQL.
  97. Type: \copyright for distribution terms
  98. \h for help with SQL commands
  99. \? for help with psql commands
  100. \g or terminate with semicolon to execute query
  101. \q to quit
  102. hammad=# \h
  103. Available help:
  104. ABORT CREATE USER
  105. ALTER AGGREGATE CREATE USER MAPPING
  106. ALTER COLLATION CREATE VIEW
  107. ALTER CONVERSION DEALLOCATE
  108. ALTER DATABASE DECLARE
  109. ALTER DEFAULT PRIVILEGES DELETE
  110. ALTER DOMAIN DISCARD
  111. ALTER EVENT TRIGGER DO
  112. ALTER EXTENSION DROP ACCESS METHOD
  113. ALTER FOREIGN DATA WRAPPER DROP AGGREGATE
  114. ALTER FOREIGN TABLE DROP CAST
  115. ALTER FUNCTION DROP COLLATION
  116. ALTER GROUP DROP CONVERSION
  117. ALTER INDEX DROP DATABASE
  118. ALTER LANGUAGE DROP DOMAIN
  119. ALTER LARGE OBJECT DROP EVENT TRIGGER
  120. ALTER MATERIALIZED VIEW DROP EXTENSION
  121. ALTER OPERATOR DROP FOREIGN DATA WRAPPER
  122. ALTER OPERATOR CLASS DROP FOREIGN TABLE
  123. ALTER OPERATOR FAMILY DROP FUNCTION
  124. ALTER POLICY DROP GROUP
  125. ALTER PROCEDURE DROP INDEX
  126. ALTER PUBLICATION DROP LANGUAGE
  127. ALTER ROLE DROP MATERIALIZED VIEW
  128. ALTER ROUTINE DROP OPERATOR
  129. ALTER RULE DROP OPERATOR CLASS
  130. ALTER SCHEMA DROP OPERATOR FAMILY
  131. ALTER SEQUENCE DROP OWNED
  132. ALTER SERVER DROP POLICY
  133. ALTER STATISTICS DROP PROCEDURE
  134. ALTER SUBSCRIPTION DROP PUBLICATION
  135. ALTER SYSTEM DROP ROLE
  136. ALTER TABLE DROP ROUTINE
  137. ALTER TABLESPACE DROP RULE
  138. ALTER TEXT SEARCH CONFIGURATION DROP SCHEMA
  139. ALTER TEXT SEARCH DICTIONARY DROP SEQUENCE
  140. ALTER TEXT SEARCH PARSER DROP SERVER
  141. ALTER TEXT SEARCH TEMPLATE DROP STATISTICS
  142. ALTER TRIGGER DROP SUBSCRIPTION
  143. ALTER TYPE DROP TABLE
  144. ALTER USER DROP TABLESPACE
  145. ALTER USER MAPPING DROP TEXT SEARCH CONFIGURATION
  146. ALTER VIEW DROP TEXT SEARCH DICTIONARY
  147. ANALYZE DROP TEXT SEARCH PARSER
  148. BEGIN DROP TEXT SEARCH TEMPLATE
  149. CALL DROP TRANSFORM
  150. CHECKPOINT DROP TRIGGER
  151. CLOSE DROP TYPE
  152. CLUSTER DROP USER
  153. COMMENT DROP USER MAPPING
  154. COMMIT DROP VIEW
  155. COMMIT PREPARED END
  156. COPY EXECUTE
  157. CREATE ACCESS METHOD EXPLAIN
  158. CREATE AGGREGATE FETCH
  159. CREATE CAST GRANT
  160. CREATE COLLATION IMPORT FOREIGN SCHEMA
  161. CREATE CONVERSION INSERT
  162. CREATE DATABASE LISTEN
  163. CREATE DOMAIN LOAD
  164. hammad=# \?
  165. General
  166. \copyright show PostgreSQL usage and distribution terms
  167. \crosstabview [COLUMNS] execute query and display results in crosstab
  168. \errverbose show most recent error message at maximum verbosity
  169. \g [FILE] or ; execute query (and send results to file or |pipe)
  170. \gdesc describe result of query, without executing it
  171. \gexec execute query, then execute each value in its result
  172. \gset [PREFIX] execute query and store results in psql variables
  173. \gx [FILE] as \g, but forces expanded output mode
  174. \q quit psql
  175. \watch [SEC] execute query every SEC seconds
  176.  
  177. Help
  178. \? [commands] show help on backslash commands
  179. \? options show help on psql command-line options
  180. \? variables show help on special variables
  181. \h [NAME] help on syntax of SQL commands, * for all commands
  182.  
  183. Query Buffer
  184. \e [FILE] [LINE] edit the query buffer (or file) with external editor
  185. \ef [FUNCNAME [LINE]] edit function definition with external editor
  186. \ev [VIEWNAME [LINE]] edit view definition with external editor
  187. \p show the contents of the query buffer
  188. \r reset (clear) the query buffer
  189. \s [FILE] display history or save it to file
  190. \w FILE write query buffer to file
  191.  
  192. Input/Output
  193. \copy ... perform SQL COPY with data stream to the client host
  194. \echo [STRING] write string to standard output
  195. \i FILE execute commands from file
  196. \ir FILE as \i, but relative to location of current script
  197. \o [FILE] send all query results to file or |pipe
  198. \qecho [STRING] write string to query output stream (see \o)
  199.  
  200. Conditional
  201. \if EXPR begin conditional block
  202. \elif EXPR alternative within current conditional block
  203. \else final alternative within current conditional block
  204. \endif end conditional block
  205.  
  206. Informational
  207. (options: S = show system objects, + = additional detail)
  208. \d[S+] list tables, views, and sequences
  209. \d[S+] NAME describe table, view, sequence, or index
  210. \da[S] [PATTERN] list aggregates
  211. \dA[+] [PATTERN] list access methods
  212. \db[+] [PATTERN] list tablespaces
  213. \dc[S+] [PATTERN] list conversions
  214. \dC[+] [PATTERN] list casts
  215. \dd[S] [PATTERN] show object descriptions not displayed elsewhere
  216. \dD[S+] [PATTERN] list domains
  217. \ddp [PATTERN] list default privileges
  218. \dE[S+] [PATTERN] list foreign tables
  219. \det[+] [PATTERN] list foreign tables
  220. \des[+] [PATTERN] list foreign servers
  221. \deu[+] [PATTERN] list user mappings
  222. \dew[+] [PATTERN] list foreign-data wrappers
  223. \df[anptw][S+] [PATRN] list [only agg/normal/procedures/trigger/window] functions
  224. \dF[+] [PATTERN] list text search configurations
  225. \dFd[+] [PATTERN] list text search dictionaries
  226. \dFp[+] [PATTERN] list text search parsers
  227. \dFt[+] [PATTERN] list text search templates
  228. \dg[S+] [PATTERN] list roles
  229. \di[S+] [PATTERN] list indexes
  230. \dl list large objects, same as \lo_list
  231. \dL[S+] [PATTERN] list procedural languages
  232. \dm[S+] [PATTERN] list materialized views
  233. \dn[S+] [PATTERN] list schemas
  234. \do[S] [PATTERN] list operators
  235. \dO[S+] [PATTERN] list collations
  236. \dp [PATTERN] list table, view, and sequence access privileges
  237. \drds [PATRN1 [PATRN2]] list per-database role settings
  238. \dRp[+] [PATTERN] list replication publications
  239. \dRs[+] [PATTERN] list replication subscriptions
  240. \ds[S+] [PATTERN] list sequences
  241. \dt[S+] [PATTERN] list tables
  242. \dT[S+] [PATTERN] list data types
  243. \du[S+] [PATTERN] list roles
  244. \dv[S+] [PATTERN] list views
  245. \dx[+] [PATTERN] list extensions
  246. \dy [PATTERN] list event triggers
  247. \l[+] [PATTERN] list databases
  248. \sf[+] FUNCNAME show a function's definition
  249. \sv[+] VIEWNAME show a view's definition
  250. \z [PATTERN] same as \dp
  251.  
  252. Formatting
  253. \a toggle between unaligned and aligned output mode
  254. \C [STRING] set table title, or unset if none
  255. \f [STRING] show or set field separator for unaligned query output
  256. \H toggle HTML output mode (currently off)
  257. \pset [NAME [VALUE]] set table output option
  258. (NAME := {border|columns|expanded|fieldsep|fieldsep_zero|
  259. footer|format|linestyle|null|numericlocale|pager|
  260. pager_min_lines|recordsep|recordsep_zero|tableattr|title|
  261. tuples_only|unicode_border_linestyle|
  262. unicode_column_linestyle|unicode_header_linestyle})
  263. \t [on|off] show only rows (currently off)
  264. \T [STRING] set HTML <table> tag attributes, or unset if none
  265. \x [on|off|auto] toggle expanded output (currently off)
  266.  
  267. Connection
  268. \c[onnect] {[DBNAME|- USER|- HOST|- PORT|-] | conninfo}
  269. connect to new database (currently "hammad")
  270. \conninfo display information about current connection
  271. \encoding [ENCODING] show or set client encoding
  272. \password [USERNAME] securely change the password for a user
  273.  
  274. Operating System
  275. \cd [DIR] change the current working directory
  276. \setenv NAME [VALUE] set or unset environment variable
  277. \timing [on|off] toggle timing of commands (currently off)
  278. \! [COMMAND] execute command in shell or start interactive shell
  279.  
  280. Variables
  281. \prompt [TEXT] NAME prompt user to set internal variable
  282. \set [NAME [VALUE]] set internal variable, or list all if no parameters
  283. \unset NAME unset (delete) internal variable
  284.  
  285. Large Objects
  286. \lo_export LOBOID FILE
  287. \lo_import FILE [COMMENT]
  288. \lo_list
  289. \lo_unlink LOBOID large object operations
  290. hammad=# \l
  291. List of databases
  292. Name | Owner | Encoding | Collate | Ctype | Access privileges
  293. -----------------+----------+----------+-------------+-------------+-----------------------
  294. backendcalltime | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  295. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  296. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  297. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  298. | | | | | postgres=CTc/postgres
  299. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  300. | | | | | postgres=CTc/postgres
  301. (5 rows)
  302.  
  303. hammad=# USE backendcalltime;
  304. ERROR: syntax error at or near "USE"
  305. LINE 1: USE backendcalltime;
  306. ^
  307. hammad=# \c backendcalltime
  308. You are now connected to database "backendcalltime" as user "hammad".
  309. backendcalltime=# \q
  310.  
  311. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  312. $ psql backendcalltime <
  313.  
  314. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  315. $ open ..
  316.  
  317. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  318. $ psql backendcalltime < backendcalltime.dump
  319. The input is a PostgreSQL custom-format dump.
  320. Use the pg_restore command-line client to restore this dump to a database.
  321.  
  322.  
  323. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  324. $ pg_restore -O -d backendcalltime backendcalltime.dump
  325. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  326. pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA public postgres
  327. pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
  328. Command was: CREATE SCHEMA public;
  329.  
  330.  
  331.  
  332. WARNING: errors ignored on restore: 1
  333.  
  334. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  335. $ psql
  336. psql (11.0)
  337. Type "help" for help.
  338.  
  339. hammad=# \l
  340. List of databases
  341. Name | Owner | Encoding | Collate | Ctype | Access privileges
  342. -----------------+----------+----------+-------------+-------------+-----------------------
  343. backendcalltime | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  344. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  345. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  346. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  347. | | | | | postgres=CTc/postgres
  348. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  349. | | | | | postgres=CTc/postgres
  350. (5 rows)
  351.  
  352. hammad=# \c backendcalltime
  353. You are now connected to database "backendcalltime" as user "hammad".
  354. backendcalltime=# \?
  355. General
  356. \copyright show PostgreSQL usage and distribution terms
  357. \crosstabview [COLUMNS] execute query and display results in crosstab
  358. \errverbose show most recent error message at maximum verbosity
  359. \g [FILE] or ; execute query (and send results to file or |pipe)
  360. \gdesc describe result of query, without executing it
  361. \gexec execute query, then execute each value in its result
  362. \gset [PREFIX] execute query and store results in psql variables
  363. \gx [FILE] as \g, but forces expanded output mode
  364. \q quit psql
  365. \watch [SEC] execute query every SEC seconds
  366.  
  367. Help
  368. \? [commands] show help on backslash commands
  369. \? options show help on psql command-line options
  370. \? variables show help on special variables
  371. \h [NAME] help on syntax of SQL commands, * for all commands
  372.  
  373. Query Buffer
  374. \e [FILE] [LINE] edit the query buffer (or file) with external editor
  375. \ef [FUNCNAME [LINE]] edit function definition with external editor
  376. \ev [VIEWNAME [LINE]] edit view definition with external editor
  377. \p show the contents of the query buffer
  378. \r reset (clear) the query buffer
  379. \s [FILE] display history or save it to file
  380. \w FILE write query buffer to file
  381.  
  382. Input/Output
  383. \copy ... perform SQL COPY with data stream to the client host
  384. \echo [STRING] write string to standard output
  385. \i FILE execute commands from file
  386. \ir FILE as \i, but relative to location of current script
  387. \o [FILE] send all query results to file or |pipe
  388. \qecho [STRING] write string to query output stream (see \o)
  389.  
  390. Conditional
  391. \if EXPR begin conditional block
  392. \elif EXPR alternative within current conditional block
  393. \else final alternative within current conditional block
  394. \endif end conditional block
  395.  
  396. Informational
  397. (options: S = show system objects, + = additional detail)
  398. \d[S+] list tables, views, and sequences
  399. \d[S+] NAME describe table, view, sequence, or index
  400. \da[S] [PATTERN] list aggregates
  401. \dA[+] [PATTERN] list access methods
  402. \db[+] [PATTERN] list tablespaces
  403. \dc[S+] [PATTERN] list conversions
  404. \dC[+] [PATTERN] list casts
  405. \dd[S] [PATTERN] show object descriptions not displayed elsewhere
  406. \dD[S+] [PATTERN] list domains
  407. \ddp [PATTERN] list default privileges
  408. \dE[S+] [PATTERN] list foreign tables
  409. \det[+] [PATTERN] list foreign tables
  410. \des[+] [PATTERN] list foreign servers
  411. \deu[+] [PATTERN] list user mappings
  412. \dew[+] [PATTERN] list foreign-data wrappers
  413. \df[anptw][S+] [PATRN] list [only agg/normal/procedures/trigger/window] functions
  414. \dF[+] [PATTERN] list text search configurations
  415. \dFd[+] [PATTERN] list text search dictionaries
  416. \dFp[+] [PATTERN] list text search parsers
  417. \dFt[+] [PATTERN] list text search templates
  418. \dg[S+] [PATTERN] list roles
  419. \di[S+] [PATTERN] list indexes
  420. \dl list large objects, same as \lo_list
  421. \dL[S+] [PATTERN] list procedural languages
  422. \dm[S+] [PATTERN] list materialized views
  423. \dn[S+] [PATTERN] list schemas
  424. \do[S] [PATTERN] list operators
  425. \dO[S+] [PATTERN] list collations
  426. \dp [PATTERN] list table, view, and sequence access privileges
  427. \drds [PATRN1 [PATRN2]] list per-database role settings
  428. \dRp[+] [PATTERN] list replication publications
  429. \dRs[+] [PATTERN] list replication subscriptions
  430. \ds[S+] [PATTERN] list sequences
  431. \dt[S+] [PATTERN] list tables
  432. \dT[S+] [PATTERN] list data types
  433. \du[S+] [PATTERN] list roles
  434. \dv[S+] [PATTERN] list views
  435. \dx[+] [PATTERN] list extensions
  436. \dy [PATTERN] list event triggers
  437. \l[+] [PATTERN] list databases
  438. \sf[+] FUNCNAME show a function's definition
  439. \sv[+] VIEWNAME show a view's definition
  440. \z [PATTERN] same as \dp
  441.  
  442. Formatting
  443. \a toggle between unaligned and aligned output mode
  444. \C [STRING] set table title, or unset if none
  445. \f [STRING] show or set field separator for unaligned query output
  446. \H toggle HTML output mode (currently off)
  447. General
  448. \copyright show PostgreSQL usage and distribution terms
  449. \crosstabview [COLUMNS] execute query and display results in crosstab
  450. \errverbose show most recent error message at maximum verbosity
  451. \g [FILE] or ; execute query (and send results to file or |pipe)
  452. \gdesc describe result of query, without executing it
  453. \gexec execute query, then execute each value in its result
  454. \gset [PREFIX] execute query and store results in psql variables
  455. \gx [FILE] as \g, but forces expanded output mode
  456. \q quit psql
  457. \watch [SEC] execute query every SEC seconds
  458.  
  459. Help
  460. \? [commands] show help on backslash commands
  461. \? options show help on psql command-line options
  462. \? variables show help on special variables
  463. \h [NAME] help on syntax of SQL commands, * for all commands
  464.  
  465. Query Buffer
  466. \e [FILE] [LINE] edit the query buffer (or file) with external editor
  467. \ef [FUNCNAME [LINE]] edit function definition with external editor
  468. \ev [VIEWNAME [LINE]] edit view definition with external editor
  469. \p show the contents of the query buffer
  470. \r reset (clear) the query buffer
  471. \s [FILE] display history or save it to file
  472. \w FILE write query buffer to file
  473.  
  474. Input/Output
  475. \copy ... perform SQL COPY with data stream to the client host
  476. backendcalltime=# \h
  477. Available help:
  478. ABORT CREATE USER
  479. ALTER AGGREGATE CREATE USER MAPPING
  480. ALTER COLLATION CREATE VIEW
  481. ALTER CONVERSION DEALLOCATE
  482. ALTER DATABASE DECLARE
  483. ALTER DEFAULT PRIVILEGES DELETE
  484. ALTER DOMAIN DISCARD
  485. ALTER EVENT TRIGGER DO
  486. ALTER EXTENSION DROP ACCESS METHOD
  487. ALTER FOREIGN DATA WRAPPER DROP AGGREGATE
  488. ALTER FOREIGN TABLE DROP CAST
  489. ALTER FUNCTION DROP COLLATION
  490. ALTER GROUP DROP CONVERSION
  491. ALTER INDEX DROP DATABASE
  492. ALTER LANGUAGE DROP DOMAIN
  493. ALTER LARGE OBJECT DROP EVENT TRIGGER
  494. ALTER MATERIALIZED VIEW DROP EXTENSION
  495. ALTER OPERATOR DROP FOREIGN DATA WRAPPER
  496. ALTER OPERATOR CLASS DROP FOREIGN TABLE
  497. ALTER OPERATOR FAMILY DROP FUNCTION
  498. ALTER POLICY DROP GROUP
  499. ALTER PROCEDURE DROP INDEX
  500. ALTER PUBLICATION DROP LANGUAGE
  501. ALTER ROLE DROP MATERIALIZED VIEW
  502. ALTER ROUTINE DROP OPERATOR
  503. ALTER RULE DROP OPERATOR CLASS
  504. ALTER SCHEMA DROP OPERATOR FAMILY
  505. ALTER SEQUENCE DROP OWNED
  506. ALTER SERVER DROP POLICY
  507. ALTER STATISTICS DROP PROCEDURE
  508. ALTER SUBSCRIPTION DROP PUBLICATION
  509. ALTER SYSTEM DROP ROLE
  510. ALTER TABLE DROP ROUTINE
  511. ALTER TABLESPACE DROP RULE
  512. ALTER TEXT SEARCH CONFIGURATION DROP SCHEMA
  513. ALTER TEXT SEARCH DICTIONARY DROP SEQUENCE
  514. ALTER TEXT SEARCH PARSER DROP SERVER
  515. ALTER TEXT SEARCH TEMPLATE DROP STATISTICS
  516. ALTER TRIGGER DROP SUBSCRIPTION
  517. ALTER TYPE DROP TABLE
  518. ALTER USER DROP TABLESPACE
  519. ALTER USER MAPPING DROP TEXT SEARCH CONFIGURATION
  520. ALTER VIEW DROP TEXT SEARCH DICTIONARY
  521. ANALYZE DROP TEXT SEARCH PARSER
  522. BEGIN DROP TEXT SEARCH TEMPLATE
  523. CALL DROP TRANSFORM
  524. CHECKPOINT DROP TRIGGER
  525. CLOSE DROP TYPE
  526. CLUSTER DROP USER
  527. COMMENT DROP USER MAPPING
  528. COMMIT DROP VIEW
  529. COMMIT PREPARED END
  530. COPY EXECUTE
  531. CREATE ACCESS METHOD EXPLAIN
  532. CREATE AGGREGATE FETCH
  533. CREATE CAST GRANT
  534. CREATE COLLATION IMPORT FOREIGN SCHEMA
  535. CREATE CONVERSION INSERT
  536. CREATE DATABASE LISTEN
  537. CREATE DOMAIN LOAD
  538. CREATE EVENT TRIGGER LOCK
  539. CREATE EXTENSION MOVE
  540. backendcalltime=# DROP DATABASE backendcalltime;
  541. ERROR: cannot drop the currently open database
  542. backendcalltime=# \l
  543. List of databases
  544. Name | Owner | Encoding | Collate | Ctype | Access privileges
  545. -----------------+----------+----------+-------------+-------------+-----------------------
  546. backendcalltime | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  547. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  548. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  549. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  550. | | | | | postgres=CTc/postgres
  551. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  552. | | | | | postgres=CTc/postgres
  553. (5 rows)
  554.  
  555. backendcalltime=# \c hammad
  556. You are now connected to database "hammad" as user "hammad".
  557. hammad=# DROP DATABASE backendcalltime;
  558. DROP DATABASE
  559. hammad=# \l
  560. List of databases
  561. Name | Owner | Encoding | Collate | Ctype | Access privileges
  562. -----------+----------+----------+-------------+-------------+-----------------------
  563. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  564. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  565. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  566. | | | | | postgres=CTc/postgres
  567. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  568. | | | | | postgres=CTc/postgres
  569. (4 rows)
  570.  
  571. hammad=# \q
  572.  
  573. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  574. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  575. pg_restore: [archiver (db)] connection to database "backendcalltime" failed: FATAL: database "backendcalltime" does not exist
  576.  
  577. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  578. $ psql
  579. psql (11.0)
  580. Type "help" for help.
  581.  
  582. hammad=# CREATE DATABASE backendcalltime;
  583. CREATE DATABASE
  584. hammad=# \l
  585. List of databases
  586. Name | Owner | Encoding | Collate | Ctype | Access privileges
  587. -----------------+----------+----------+-------------+-------------+-----------------------
  588. backendcalltime | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  589. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  590. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  591. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  592. | | | | | postgres=CTc/postgres
  593. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  594. | | | | | postgres=CTc/postgres
  595. (5 rows)
  596.  
  597. hammad=# \q
  598.  
  599. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  600. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  601. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  602. pg_restore: [archiver (db)] Error from TOC entry 3250; 1262 18089 DATABASE backendcalltime jasontoups
  603. pg_restore: [archiver (db)] could not execute query: ERROR: database "backendcalltime" already exists
  604. Command was: CREATE DATABASE backendcalltime WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
  605.  
  606.  
  607.  
  608. pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA public postgres
  609. pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
  610. Command was: CREATE SCHEMA public;
  611.  
  612.  
  613.  
  614. WARNING: errors ignored on restore: 2
  615.  
  616. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  617. $ psql
  618. psql (11.0)
  619. Type "help" for help.
  620.  
  621. hammad=# DROP DATABASE backendcalltime;
  622. DROP DATABASE
  623. hammad=# \l
  624. List of databases
  625. Name | Owner | Encoding | Collate | Ctype | Access privileges
  626. -----------+----------+----------+-------------+-------------+-----------------------
  627. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  628. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  629. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  630. | | | | | postgres=CTc/postgres
  631. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  632. | | | | | postgres=CTc/postgres
  633. (4 rows)
  634.  
  635. hammad=# \q
  636.  
  637. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  638. $ pg_restore -O -C -d backendcalltime.dump
  639. ^C
  640.  
  641. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  642. $ psql
  643. psql (11.0)
  644. Type "help" for help.
  645.  
  646. hammad=# \l
  647. List of databases
  648. Name | Owner | Encoding | Collate | Ctype | Access privileges
  649. -----------+----------+----------+-------------+-------------+-----------------------
  650. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  651. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  652. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  653. | | | | | postgres=CTc/postgres
  654. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  655. | | | | | postgres=CTc/postgres
  656. (4 rows)
  657.  
  658. hammad=# \q
  659.  
  660. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
  661. $ pg_restore -O -C -d backendcalltime > backendcalltime.dump
  662. ^C
  663.  
  664. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  665. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  666. pg_restore: [archiver] input file is too short (read 0, expected 5)
  667.  
  668. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  669. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  670. pg_restore: [archiver] input file is too short (read 0, expected 5)
  671.  
  672. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  673. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  674. pg_restore: [archiver] input file is too short (read 0, expected 5)
  675.  
  676. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  677. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  678. pg_restore: [archiver] input file is too short (read 0, expected 5)
  679.  
  680. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  681. $ psql
  682. psql (11.0)
  683. Type "help" for help.
  684.  
  685. hammad=# CREATE DATABASE backendcalltime;
  686. CREATE DATABASE
  687. hammad=# \l
  688. List of databases
  689. Name | Owner | Encoding | Collate | Ctype | Access privileges
  690. -----------------+----------+----------+-------------+-------------+-----------------------
  691. backendcalltime | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  692. hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  693. postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
  694. template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  695. | | | | | postgres=CTc/postgres
  696. template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
  697. | | | | | postgres=CTc/postgres
  698. (5 rows)
  699.  
  700. hammad=# \q
  701.  
  702. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  703. $ pg_restore -O -C -d backendcalltime backendcalltime.dump
  704. pg_restore: [archiver] input file is too short (read 0, expected 5)
  705.  
  706. hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
  707. $
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!