| From: | mbneto <mbneto(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Migrate 8.0 dump to 7.4 |
| Date: | 2007-01-21 15:51:46 |
| Message-ID: | 5cf776b80701210751q211d2a8fvafe527a6eada0a54@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a dumpall file generated from a 8.0 version that I need to import
back to a 7.4 server.
Is there a way to do that?
a psql -f db.out template1 gives me
psql:/tmp/db.out:687: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:697: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:707: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:717: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:727: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:737: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:747: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:757: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:767: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:777: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:787: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:797: ERROR: syntax error next "INDEX" at character 7
Any idea?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shashank | 2007-01-21 16:01:57 | Re: More grist for the PostgreSQL vs MySQL mill |
| Previous Message | Joshua D. Drake | 2007-01-21 15:39:22 | Re: More grist for the PostgreSQL vs MySQL mill |