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.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
>
>