Difference between revisions of "Pg restore"
Jump to navigation
Jump to search
(Created page with "{{lc}} == See also == * {{pg}} * {{PostgreSQL}} Category:Backup] Category:PostgreSQL") |
|||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| + | * https://www.postgresql.org/docs/current/app-pgrestore.html | ||
| + | |||
| + | |||
| + | |||
| + | pg_restore --jobs="${numcores}" --format=directory [[--dbname]]=[[cexplorer]] "${tmp_dir}/db/" | ||
| + | |||
| + | |||
| + | 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]] | ||
| + | |||
| + | [[could not open input file]] | ||
| + | |||
| + | == Related == | ||
| + | * <code>[[pg_dump]]</code> | ||
| + | * [[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:
