The following bug has been logged online:

Bug reference: 2521
Logged by: Simon, Attila
Email address: iroda (AT) continentalinvest (DOT) hu
PostgreSQL version: 8.1.4
Operating system: MS Windows XP (the worst)
Description: pg_restore is hanging
Details:

We have dumped a database with pg_dump and tried to restore it. Then the
pg_restore program started to hanging, does not give any info even the
verbose flag has been turned on. But the dmp file can be executed as an SQL
script. Can you give me any info about?
Attila

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Sun, Jul 09, 2006 at 08:15:27AM +0000, Simon, Attila wrote:
What were the exact pg_dump and pg_restore commands you ran? When
you say that pg_restore started hanging, do you mean that it displayed
some output and then hung, or that it never displayed anything? Is
it possible that you ran pg_restore without any arguments and that
it's waiting to read from standard input (the terminal window)? If
the dump file contains SQL statements then why are you using
pg_restore instead of psql?

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match