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
