6.3.1 -> 6.3.2 problems

I am trying to move some of my databases from our older 6.3.1 database
server, to our newer and faster server running 6.3.2 (all under linux).

Basically I am attempting to do:

pg_dump database > /tmp/database.data

then on the new machine

createdb database
psql -f /tmp/database.data database

I have also tried

createdb database
psql -e database < /tmp/database.data

Both freeze up when the actual data is to be entered:

COPY files FROM stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
>>

it just sits their.  What am I doing wrong?  I have found the following to
work:

createdb database
do the above process, so at least the schema is created
on the older machine do "copy table to 'filename';"
on the newer machine do "copy table from 'filename';"

but I have to do those "copies" for each and every table, and that can be
alot of tables!  Any ideas? Should this be working?

Brian


--------------------------------------------------------------------------
Brian Feeny (BF304)   | ShreveNet Inc. - Premium Internet Service Provider
Network Administrator | Shreveport, Louisiana - http://www.shreve.net/
signal@shreve.net     | Web Hosting, Virtual Domains, Storefronts,
(318)222-2NET x 109   | Database/Web Integration, 56k, ISDN, T1