Difference between revisions of "Pg restore"

Revision as of 13:08, 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

Revision as of 04:59, 3 May 2023 (edit) Welcome (talk \| contribs) (→‎See also) ← Older edit		Revision as of 13:08, 3 May 2023 (edit) (undo) Welcome (talk \| contribs) Newer edit →
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/"