Re: pg_dump and restore

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(dot)b(at)verse(dot)in
> <mailto:suhas(dot)b(at)verse(dot)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(at)postgresql(dot)org
> <mailto:pgsql-admin(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>