You can test restore by change CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql; to CREATE PROCEDURAL LANGUAGE plpgsql;
Tuan Hoang Anh 2010/12/15 Andrus Moor <eetas...@online.ee> > Server is > > PostgreSQL 8.4.3 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian > 4.3.2-1.1) 4.3.2, 32-bit > > Backup is created using 9.0RC pg_dump.exe file > > Trying to restore from this backup to same server using 9.0RC > pg_restore.exe > causes error > > "..\pg_dump\pg_restore.exe" -h mysite.com -U > eur1_owner -i --no-privileges --no-owner -d "eur1" "C:\mybackup.backup" > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 929; 2612 16389 PROCEDURAL > LANGUAGE plpgsql postgres > pg_restore: [archiver (db)] could not execute query: ERROR: syntax error > at > or near "PROCEDURAL" > LINE 1: CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql; > > > How to restore from this backup to 8.4.3 server using 9.0 pg_restore ? > > Andrus. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
