I'm having a problem restoring my Postgres 9.0 database into a 9.3 version.
I did the backup with this command:
pg_dump -U user database -f /root/mydb.sql
And when I send the backup to the new server and try to restore it I get this error:
psql.bin:/root/mydb.sql:5628157: invalid command \n
psql.bin:/root/mydb.sql:5628158: invalid command \n
psql.bin:/root/mydb.sql:5628159: invalid command \n
psql.bin:/root/mydb.sql:5628160: invalid command \n
psql.bin:/root/mydb.sql:5628161: invalid command \n
psql.bin:/root/mydb.sql:5628162: invalid command \n
psql.bin:/root/mydb.sql:5628163: invalid command \n
psql.bin:/root/mydb.sql:5628164: invalid command \n
psql.bin:/root/mydb.sql:5628165: invalid command \n
psql.bin:/root/mydb.sql:5628166: ERROR: syntax error at or near "PageRange"
LINE 1: PageRange=1-2highFoto_ALTA
Asked by jask
(113 rep)
Aug 26, 2016, 02:05 PM
Last activity: Jul 22, 2025, 10:22 AM
Last activity: Jul 22, 2025, 10:22 AM