Fully restore a DBMS backup to a new database.
To restore the full backup to a new database, run the command from the base
directory of the PostgreSQL data directory:
$ tar -xvf backup.tar
For more information, the
PostgreSQL website is a useful resource.