Difference between revisions of "Pg restore"

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
  
  
  pg_restore --jobs="${numcores}" --format=directory [[--dbname]]=cexplorer "${tmp_dir}/db/"
+
  pg_restore --jobs="${numcores}" --format=directory [[--dbname]]=[[cexplorer]] "${tmp_dir}/db/"
  
  
Line 14: Line 14:
  
 
  [[pg_restore --help]]
 
  [[pg_restore --help]]
 +
 +
[[could not open input file]]
  
 
== Related ==
 
== Related ==

Latest revision as of 14:25, 3 May 2023


pg_restore --jobs="${numcores}" --format=directory --dbname=cexplorer "${tmp_dir}/db/"


cat filename.tgz | tar -xzOf - path/to/filename.backup | pg_restore -U username -d databasename


cat filename.tgz | tar -xzO path/to/filename.backup | pg_restore -U username -d databasename


pg_restore --help
could not open input file

Related[edit]

See also[edit]

Advertising: