Difference between revisions of "Pg restore"
Jump to navigation
Jump to search
| (4 intermediate revisions 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/" |
| − | cat filename.tgz | [[tar -xzO]] filename.backup | pg_restore -U username -d databasename | + | cat filename.tgz | [[tar -xz]]Of - 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]] | [[pg_restore --help]] | ||
| + | |||
| + | [[could not open input file]] | ||
== Related == | == Related == | ||
* <code>[[pg_dump]]</code> | * <code>[[pg_dump]]</code> | ||
* [[Restore DB]] | * [[Restore DB]] | ||
| + | * [[psql --host]] | ||
== See also == | == See also == | ||
| + | * {{pg_restore}} | ||
* {{pg}} | * {{pg}} | ||
| − | + | ||
[[Category:Backup]]] | [[Category:Backup]]] | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
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:
