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/ [EMAIL PROTECTED] | Web Hosting, Virtual Domains, Storefronts, (318)222-2NET x 109 | Database/Web Integration, 56k, ISDN, T1
