6.3.1 -> 6.3.2 problems

Started by Brianabout 27 years ago1 messagesgeneral
Jump to latest
#1Brian
signal@shreve.net

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