From: Birta Levente <blevi.linux@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump and restore
Date: Thu, 10 Jan 2013 09:58:39 +0200
Message-ID: <50EE74AF.1060109@gmail.com> (raw)
In-Reply-To: <CAE469vDaSPCWtBC0r+u3t92q9FEZsAz1xwcLkhVPNUz=jOAxvw@mail.gmail.com>
References: <1357732123178-5739350.post@n5.nabble.com>
<CAE469vDaSPCWtBC0r+u3t92q9FEZsAz1xwcLkhVPNUz=jOAxvw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: blevi.linux@gmail.com
Subject: Re: pg_dump and restore
In-Reply-To: <50EE74AF.1060109@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox