| From: | "Andrus Moor" <eetasoft(at)online(dot)ee> |
|---|---|
| To: | <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore |
| Date: | 2010-12-16 16:47:24 |
| Message-ID: | 0CF78CBFB0EA4566A28EC3901C3D9588@andrusnotebook |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | felipe@informidia.com.br | 2010-12-16 17:13:31 | When the trigger is called my application is awaiting the finish |
| Previous Message | Adrian Klaver | 2010-12-16 16:27:01 | Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore |