Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore

On Wednesday 15 December 2010 1:29:09 am Andrus Moor wrote:
> 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.

I am not sure I follow. Are you taking a pg_dump of a 9.0 database using a 9.0
version of pg_dump and trying to restore to a 8.4.3 database or are using the
9.0 pg_dump against the 8.4.3 server and then restoring back to it? In either
case the problem you see above will probably be only the first. Going backwards
using pg_dump/pg_restore is not guaranteed to work. Your best hope if you must
do that is to do the dump in plain text format and change the problems manually
as you proceed.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com