"Andrus Moor" <eetasoft@online.ee> writes:
> I used only 9.0 dump and restore. I did the following:
> 1. Created backup copy from 8.4.3 using 9.0 pg_dump
> 2. Restored from this backup to 8.4.3 using 9.0 pg_restore
> 9.0 pg_restore fails since 8.4.3 server reports invalid sql command in
> create
> language plpgsql statement. previous pg_restores worked OK.
> Is this 9.0 pg_restore bug ?
No, this is just pilot error. Any version of pg_dump will produce
output that is meant to be loaded into the matching server version
(or a later version). If you are intending to load back into 8.4,
use the 8.4 pg_dump.
You may have been reading the recommendation to use the later version's
pg_dump when dumping an older server to perform an upgrade. It's good
advice, but only for upgrades.
regards, tom lane