Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
От | Andrus Moor |
---|---|
Тема | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore |
Дата | |
Msg-id | 0CF78CBFB0EA4566A28EC3901C3D9588@andrusnotebook обсуждение исходный текст |
Ответ на | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore (Adrian Klaver <adrian.klaver@gmail.com>) |
Ответы |
Re: How to restore from backup to 8.4.3 server using 9.0
dump/restore
|
Список | pgsql-general |
>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.
В списке pgsql-general по дате отправления: