Migrate 8.0 dump to 7.4

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: Raw Message | Whole Thread | 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?

Responses

Browse pgsql-general by date

  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