Thread: Error with pg_restore (parse error at or near "BY" at character 144
Error with pg_restore (parse error at or near "BY" at character 144
From
"nednieuws | charles"
Date:
What does this error mean: pg_restore: creating TABLE author pg_restore: creating SEQUENCE author_id pg_restore: [archiver (db)] could not execute query: ERROR: parser: parse error at or near "BY" at character 144 pg_restore: *** aborted because of error The line in question is: GRANT ALL ON TABLE author TO GROUP dvnl; [...] ); ^A^A INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ^A^A The command used to restore the db: pg_restore --dbname=dvnl --format=t --verbose --username=dvnl --no-privileges --no-owner dvnldump.tar The source db is PostgreSQL 7.4 and the target db is 7.3.3 -- Regards, Charels.
"nednieuws | charles" <charles@nednieuws.com> writes: > The source db is PostgreSQL 7.4 and the target db is 7.3.3 pg_dump is not designed to handle downgrades --- its output is intended to be loaded into pg_dump's own version or later. You should expect to have to hand-edit the output to load it into an older version. regards, tom lane