On Sun, Jan 21, 2007 at 12:27:41PM -0500, Jaime Casanova wrote: > On 1/21/07, mbneto <mbneto@xxxxxxxxx> wrote: > >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 > > you must edit your script backup manually in order to match the syntax > to that allowed in 7.4 > > in this case you can go to the line 687 (the line is indicated in > psql:/tmp/db.out:line) and fix that syntax... execute again and fix > the next message and so on ( a good idea is to put BEGIN; at the > beginning of the script and ROLLBACK at the end until you fix all > messages)... Trying a dump from the 7.4 version of pg_dump might also work... just make sure to test it. -- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)