6.3.1 -> 6.3.2 problems

From: Brian <signal(at)shreve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: 6.3.1 -> 6.3.2 problems
Date: 1999-01-22 20:39:24
Message-ID: Pine.LNX.4.02.9901221434530.11416-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)shreve(dot)net | Web Hosting, Virtual Domains, Storefronts,
(318)222-2NET x 109 | Database/Web Integration, 56k, ISDN, T1

Browse pgsql-general by date

  From Date Subject
Next Message Paulo Parola 1999-01-22 22:27:48 Bad column offset ?
Previous Message Curt Miller 1999-01-22 20:28:33 Looking for Commercial Developers - Detroit, MI