Re: pg_dump, pg_restore from 9.2 on 8.4 server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2013/7/3 Jiří Hlinka <jiri.hlinka@xxxxxxxxx>:
> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux