· 7 years ago · Jan 16, 2019, 11:24 AM
1Last login: Tue Jan 15 18:53:53 on ttys000
2
3hammad at MacBokuPro2018 in ~
4$ cd ~/dev/work/calltime/call-time-app-strapi
5
6hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
7$ npm i strapi@alpha -g
8npm 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
10npm 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.
11npm 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
14added 375 packages from 267 contributors in 19.096s
15
16hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
17$ strapi -v
183.0.0-alpha.18
19
20hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
21$ strapi start
22internal/modules/cjs/loader.js:605
23 throw err;
24 ^
25
26Error: 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
39hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
40$ open .
41
42hammad 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
52internal/modules/cjs/loader.js:605
53 throw err;
54 ^
55
56Error: 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)
67npm ERR! code ELIFECYCLE
68npm ERR! errno 1
69npm ERR! strapi-admin@3.0.0-alpha.14.5 presetup: `node ./scripts/preSetup.js`
70npm ERR! Exit status 1
71npm ERR!
72npm ERR! Failed at the strapi-admin@3.0.0-alpha.14.5 presetup script.
73npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
74npm WARN Local package.json exists, but node_modules missing, did you mean to install?
75
76npm ERR! A complete log of this run can be found in:
77npm ERR! /Users/hammad/.npm/_logs/2019-01-16T00_50_12_850Z-debug.log
78npm ERR! code ELIFECYCLE
79npm ERR! errno 1
80npm ERR! backend-call-time@0.1.0 setup: `cd admin && npm run setup`
81npm ERR! Exit status 1
82npm ERR!
83npm ERR! Failed at the backend-call-time@0.1.0 setup script.
84npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
85npm WARN Local package.json exists, but node_modules missing, did you mean to install?
86
87npm ERR! A complete log of this run can be found in:
88npm ERR! /Users/hammad/.npm/_logs/2019-01-16T00_50_12_870Z-debug.log
89
90hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
91$ psql
92psql (11.0)
93Type "help" for help.
94
95hammad=# help
96You are using psql, the command-line interface to PostgreSQL.
97Type: \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
102hammad=# \h
103Available 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
164hammad=# \?
165General
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
177Help
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
183Query 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
192Input/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
200Conditional
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
206Informational
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
252Formatting
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
267Connection
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
274Operating 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
280Variables
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
285Large Objects
286 \lo_export LOBOID FILE
287 \lo_import FILE [COMMENT]
288 \lo_list
289 \lo_unlink LOBOID large object operations
290hammad=# \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
303hammad=# USE backendcalltime;
304ERROR: syntax error at or near "USE"
305LINE 1: USE backendcalltime;
306 ^
307hammad=# \c backendcalltime
308You are now connected to database "backendcalltime" as user "hammad".
309backendcalltime=# \q
310
311hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
312$ psql backendcalltime <
313
314hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
315$ open ..
316
317hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
318$ psql backendcalltime < backendcalltime.dump
319The input is a PostgreSQL custom-format dump.
320Use the pg_restore command-line client to restore this dump to a database.
321
322
323hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
324$ pg_restore -O -d backendcalltime backendcalltime.dump
325pg_restore: [archiver (db)] Error while PROCESSING TOC:
326pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA public postgres
327pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
328 Command was: CREATE SCHEMA public;
329
330
331
332WARNING: errors ignored on restore: 1
333
334hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
335$ psql
336psql (11.0)
337Type "help" for help.
338
339hammad=# \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
352hammad=# \c backendcalltime
353You are now connected to database "backendcalltime" as user "hammad".
354backendcalltime=# \?
355General
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
367Help
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
373Query 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
382Input/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
390Conditional
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
396Informational
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
442Formatting
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)
447General
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
459Help
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
465Query 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
474Input/Output
475 \copy ... perform SQL COPY with data stream to the client host
476backendcalltime=# \h
477Available 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
540backendcalltime=# DROP DATABASE backendcalltime;
541ERROR: cannot drop the currently open database
542backendcalltime=# \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
555backendcalltime=# \c hammad
556You are now connected to database "hammad" as user "hammad".
557hammad=# DROP DATABASE backendcalltime;
558DROP DATABASE
559hammad=# \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
571hammad=# \q
572
573hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
574$ pg_restore -O -C -d backendcalltime backendcalltime.dump
575pg_restore: [archiver (db)] connection to database "backendcalltime" failed: FATAL: database "backendcalltime" does not exist
576
577hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
578$ psql
579psql (11.0)
580Type "help" for help.
581
582hammad=# CREATE DATABASE backendcalltime;
583CREATE DATABASE
584hammad=# \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
597hammad=# \q
598
599hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
600$ pg_restore -O -C -d backendcalltime backendcalltime.dump
601pg_restore: [archiver (db)] Error while PROCESSING TOC:
602pg_restore: [archiver (db)] Error from TOC entry 3250; 1262 18089 DATABASE backendcalltime jasontoups
603pg_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
608pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA public postgres
609pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
610 Command was: CREATE SCHEMA public;
611
612
613
614WARNING: errors ignored on restore: 2
615
616hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
617$ psql
618psql (11.0)
619Type "help" for help.
620
621hammad=# DROP DATABASE backendcalltime;
622DROP DATABASE
623hammad=# \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
635hammad=# \q
636
637hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
638$ pg_restore -O -C -d backendcalltime.dump
639^C
640
641hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
642$ psql
643psql (11.0)
644Type "help" for help.
645
646hammad=# \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
658hammad=# \q
659
660hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist
661$ pg_restore -O -C -d backendcalltime > backendcalltime.dump
662^C
663
664hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
665$ pg_restore -O -C -d backendcalltime backendcalltime.dump
666pg_restore: [archiver] input file is too short (read 0, expected 5)
667
668hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
669$ pg_restore -O -C -d backendcalltime backendcalltime.dump
670pg_restore: [archiver] input file is too short (read 0, expected 5)
671
672hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
673$ pg_restore -O -C -d backendcalltime backendcalltime.dump
674pg_restore: [archiver] input file is too short (read 0, expected 5)
675
676hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
677$ pg_restore -O -C -d backendcalltime backendcalltime.dump
678pg_restore: [archiver] input file is too short (read 0, expected 5)
679
680hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
681$ psql
682psql (11.0)
683Type "help" for help.
684
685hammad=# CREATE DATABASE backendcalltime;
686CREATE DATABASE
687hammad=# \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
700hammad=# \q
701
702hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
703$ pg_restore -O -C -d backendcalltime backendcalltime.dump
704pg_restore: [archiver] input file is too short (read 0, expected 5)
705
706hammad at MacBokuPro2018 in ~/dev/work/calltime/call-time-app-strapi on calllist [!]
707$