"Andrus Moor" <eetasoft@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
