| From: | George Armhold <armhold(at)cs(dot)rutgers(dot)edu> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) |
| Date: | 2000-11-22 19:18:18 |
| Message-ID: | 3A1C1BFA.CC7AFDBF@cs.rutgers.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm trying to migrate from PostgreSQL 6.3.2 under IRIX to version
7.0.2 under RedHat 7.0. I've dumped my old database with
"pg_dumpall -o > db.backup", but I'm having problems restoring this
data to the new machine. I'm using "psql -d template1 < db.backup" to
restore the data, but I'm getting parse errors from psql:
> You are now connected to database template1.
> SELECT
> DELETE 0
> DROP
> You are now connected to database template1 as user postgres.
> CREATE DATABASE
> You are now connected to database armhold as user postgres.
> CREATE
> DROP
> You are now connected as new user armhold.
> psql:/home/armhold/db.backup:13: ERROR: parser: parse error at or near "-"
> psql:/home/armhold/db.backup:14: ERROR: Relation 'pfam' does not exist
> psql:/home/armhold/db.backup:20: invalid command \.
I get similar results if I dump the individual databases one by one.
I'm running the stock Postgres install that comes with Redhat 7. I've
applied all the available errata patches for Redhat. Should I expect
this to work, moving from IRIX to Linux, and from
Postgres 6.3.2 to 7.0.2 at the same time?
Thanks for any help.
--
George Armhold
Rutgers University
Bioinformatics Initiative
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandeep Joshi | 2000-11-22 19:20:11 | Re: copy table from... |
| Previous Message | Roger T. Alexander | 2000-11-22 19:04:12 | Compiling PostGresQL under Win2k |