Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore - Mailing list pgsql-general

From Andrus Moor
Subject Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Date
Msg-id 0CF78CBFB0EA4566A28EC3901C3D9588@andrusnotebook
Whole thread Raw
In response to Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Next
From: "felipe@informidia.com.br"
Date:
Subject: When the trigger is called my application is awaiting the finish