pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump, pg_restore from 9.2 on 8.4 server
3+ messages / 3 participants
[nested] [flat]
* pg_dump, pg_restore from 9.2 on 8.4 server
@ 2013-07-03 08:33 Jiří Hlinka <jiri.hlinka@gmail.com>
2013-07-03 11:53 ` Re: pg_dump, pg_restore from 9.2 on 8.4 server Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jiří Hlinka @ 2013-07-03 08:33 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I have a 8.4 server and I'd like to use --section parameter of pg_dump and
pg_restore, which is available only in 9.2.
1. Is it, in general, safe to use 9.2 tools on 8.4 server? AFAIK the tools
are backward compatible, at least in case of plain SQL commands it should
be compatible, right?
2. Does the --section parameter need support on a server side, or is it
just the client tool feature?
Thanks,
Jiri
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_dump, pg_restore from 9.2 on 8.4 server
2013-07-03 08:33 pg_dump, pg_restore from 9.2 on 8.4 server Jiří Hlinka <jiri.hlinka@gmail.com>
@ 2013-07-03 11:53 ` Ian Lawrence Barwick <barwick@gmail.com>
2013-07-03 20:50 ` Re: pg_dump, pg_restore from 9.2 on 8.4 server Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 3+ messages in thread
From: Ian Lawrence Barwick @ 2013-07-03 11:53 UTC (permalink / raw)
To: Jiří Hlinka <jiri.hlinka@gmail.com>; +Cc: pgsql-admin
2013/7/3 Jiří Hlinka <jiri.hlinka@gmail.com>:
> Hi All,
>
> I have a 8.4 server and I'd like to use --section parameter of pg_dump and
> pg_restore, which is available only in 9.2.
>
> 1. Is it, in general, safe to use 9.2 tools on 8.4 server? AFAIK the tools
> are backward compatible, at least in case of plain SQL commands it should be
> compatible, right?
pg_dump is backwards-compatible all the way to 7.0; see:
http://www.postgresql.org/docs/9.2/static/app-pgdump.html#PG-DUMP-NOTES
> 2. Does the --section parameter need support on a server side, or is it just
> the client tool feature?
It's a pg_dump feature; it seems to work fine using 9.3b2's dump
against an 8.3 database.
Regards
Ian Barwick
--
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] 3+ messages in thread
* Re: pg_dump, pg_restore from 9.2 on 8.4 server
2013-07-03 08:33 pg_dump, pg_restore from 9.2 on 8.4 server Jiří Hlinka <jiri.hlinka@gmail.com>
2013-07-03 11:53 ` Re: pg_dump, pg_restore from 9.2 on 8.4 server Ian Lawrence Barwick <barwick@gmail.com>
@ 2013-07-03 20:50 ` Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 3+ messages in thread
From: Guillaume Lelarge @ 2013-07-03 20:50 UTC (permalink / raw)
To: Ian Lawrence Barwick <barwick@gmail.com>; +Cc: Jiří Hlinka <jiri.hlinka@gmail.com>; pgsql-admin
On Wed, 2013-07-03 at 20:53 +0900, Ian Lawrence Barwick wrote:
> 2013/7/3 Jiří Hlinka <jiri.hlinka@gmail.com>:
> > Hi All,
> >
> > I have a 8.4 server and I'd like to use --section parameter of pg_dump and
> > pg_restore, which is available only in 9.2.
> >
> > 1. Is it, in general, safe to use 9.2 tools on 8.4 server? AFAIK the tools
> > are backward compatible, at least in case of plain SQL commands it should be
> > compatible, right?
>
> pg_dump is backwards-compatible all the way to 7.0; see:
> http://www.postgresql.org/docs/9.2/static/app-pgdump.html#PG-DUMP-NOTES
>
Sure, but you may not be able to restore it on a less recent release
(ie, in that case, previous than 9.2). If you use a 9.2 pg_dump, you'll
be garanteed to restore it on 9.2 and upper, not lower (not 8.4 for
instance).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.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] 3+ messages in thread
end of thread, other threads:[~2013-07-03 20:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-03 08:33 pg_dump, pg_restore from 9.2 on 8.4 server Jiří Hlinka <jiri.hlinka@gmail.com>
2013-07-03 11:53 ` Ian Lawrence Barwick <barwick@gmail.com>
2013-07-03 20:50 ` Guillaume Lelarge <guillaume@lelarge.info>
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