Message-ID: <50EE74AF.1060109@gmail.com>
Date: Thu, 10 Jan 2013 09:58:39 +0200
From: Birta Levente <blevi.linux@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64;
	rv:17.0) Gecko/20130107 Thunderbird/17.0.2
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump and restore
References: <1357732123178-5739350.post@n5.nabble.com>
	<CAE469vDaSPCWtBC0r+u3t92q9FEZsAz1xwcLkhVPNUz=jOAxvw@mail.gmail.com>
In-Reply-To: 
 <CAE469vDaSPCWtBC0r+u3t92q9FEZsAz1xwcLkhVPNUz=jOAxvw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 10/01/2013 09:47, Arun Padule wrote:
> Hi,
>
> Yes you a dump data from one version of postgres to the other version.
> But later you will facing issue with casting of data type's.
>

As documentaion said, you need to make a dump with pg_dump from the 
"destination" version. But if you want to migrate to earlier version, 
the earlier pg_dump will not work with newer database.
With pg_dump from 9.2 you can make dump from all versions and restore to 
9.2.
But you can't backup 9.0 database with pg_dump from 8.4.
You can try to dump 9.0 with pg_dump 9.0 and restore to 8.4, but no 
guarantee to work.


> e,g
>
> where '5' = 5; works in 8.0 version
>
> But same where clause through's a data type miss match on 9.1 version.
>
> These is just a one example, there might be many other functions that
> might not be used or compatible with the higher version of postgres.
>
> In this case you need to explicit on the changes in the proc or
> function. Like as below.
>
> where '5'::integer = 5;
>
> Thanks,
> Arun
>
> On Wed, Jan 9, 2013 at 5:18 PM, suhas.basavaraj12 <suhas.b@verse.in
> <mailto:suhas.b@verse.in>> wrote:
>
>     Hi,
>
>     Can we dump data from any postrgres  version and restore it to any
>     version
>     of postgres ?
>     If not , can anyone tell which version of data is compatible to   which
>     version ?
>
>     Rgrds
>     Suhas.B
>
>
>
>     --
>     View this message in context:
>     http://postgresql.1045698.n5.nabble.com/pg-dump-and-restore-tp5739350.html
>     Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
>     --
>     Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
>     <mailto:pgsql-admin@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-admin
>
>


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin