pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump and restore
5+ messages / 4 participants
[nested] [flat]
* pg_dump and restore
@ 2013-01-09 11:48 suhas.basavaraj12 <suhas.b@verse.in>
0 siblings, 1 reply; 5+ messages in thread
From: suhas.basavaraj12 @ 2013-01-09 11:48 UTC (permalink / raw)
To: pgsql-admin
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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump and restore
@ 2013-01-10 07:47 Arun Padule <arunpadule@gmail.com>
parent: suhas.basavaraj12 <suhas.b@verse.in>
0 siblings, 1 reply; 5+ messages in thread
From: Arun Padule @ 2013-01-10 07:47 UTC (permalink / raw)
To: suhas.basavaraj12 <suhas.b@verse.in>; +Cc: pgsql-admin
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.
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> 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)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump and restore
@ 2013-01-10 07:58 Birta Levente <blevi.linux@gmail.com>
parent: Arun Padule <arunpadule@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Birta Levente @ 2013-01-10 07:58 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump and restore
@ 2013-01-10 08:27 suhas.basavaraj12 <suhas.b@verse.in>
parent: Birta Levente <blevi.linux@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: suhas.basavaraj12 @ 2013-01-10 08:27 UTC (permalink / raw)
To: pgsql-admin
Thanks for the info .We will be dumping data from version 9.0 and restore to
9.1.
Rgrds
Suhas
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dump-and-restore-tp5739350p5739517.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump and restore
@ 2013-01-11 22:58 Kevin Grittner <kgrittn@mail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2013-01-11 22:58 UTC (permalink / raw)
To: suhas.basavaraj12 <suhas.b@verse.in>; pgsql-admin
suhas.basavaraj12 wrote:
> We will be dumping data from version 9.0 and restore to 9.1.
That should work fine, as long as use use pg_dump from version
9.1 to dump the 9.0 database.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2013-01-11 22:58 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-09 11:48 pg_dump and restore suhas.basavaraj12 <suhas.b@verse.in>
2013-01-10 07:47 ` Arun Padule <arunpadule@gmail.com>
2013-01-10 07:58 ` Birta Levente <blevi.linux@gmail.com>
2013-01-10 08:27 ` suhas.basavaraj12 <suhas.b@verse.in>
2013-01-11 22:58 Re: pg_dump and restore Kevin Grittner <kgrittn@mail.com>
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