Restoring pg_dump hangs Aim: backup a database and restore it in database2

pg_dump

A PG Dump has been created by issuing the following command:

c:\Temp&gt;pg_dump -U postgres postgres &gt; backupTest2.sql

Opening backupTest2.sql shows SQL statements.

restore pg_dump

However, once the backup would like to be restored in another database nothing seems to happen (number of tables in database2 remains 0, command hangs).

c:\Temp&gt;psql -U postgres -d utrechtTest &gt; backupTest2.sql

^C
This:

psql -U postgres -d utrechtTest &gt; backupTest2.sql


runs psql and writes its stdout to backupTest2.sql, which will be overwritten.

You meant:

psql -U postgres -d utrechtTest &lt; backupTest2.sql


which is better written as:

psql -U postgres -d utrechtTest -f backupTest2.sql


because if you use -f then psql can show line numbers.