How can I import a dumped database into Postgres?

·Around 1 minute

Using pg_restore, it's almost the same process as pg_dump but in reverse

pg_restore --dbname={{DBNAME}} --host={{HOST}} --port={{PORT}} --username={{USERNAME}} --password --jobs 2 {{NAME}}.dump
pg_restore --dbname={{DBNAME}} --host={{HOST}} --port={{PORT}} --username={{USERNAME}} --password --jobs 2 {{NAME}}.dump

You can use -j to parallelize restoration ie; pg_dump -j 41.

Footnotes

  1. https://www.postgresql.org/docs/current/backup-dump.html#BACKUP-DUMP-LARGE