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

>Loading a dump file into an older server may require manual editing of
> the dump file to remove syntax not understood by the older server. "

pg_restore ignores erros during restore (it only returns exit code 1).
So "manual editing of  the dump file to remove syntax not understood" is
never required.
Why this is not mentioned in docs ?

>  It is the  REPLACE clause that is causing the problem

How to force 9.0 to emit CREATE LANGUAGE command without replace clause ?

> Yea the CREATE DATABASE  TEMPLATE option is as close as it gets and you
> are already aware of its limitations.

How to make CREATE DATABASE  TEMPLATE  to work if there are connected users
to template ?
Since pg_dump works if active users are connected, CREATE DATABASE  TEMPLATE
should also work.

Andrus.