Aim: backup a database and restore it in database2
A PG Dump has been created by issuing the following command:
c:\Temp>pg_dump -U postgres postgres > backupTest2.sql
backupTest2.sql shows SQL statements.
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>psql -U postgres -d utrechtTest > backupTest2.sql ^C