On Fri, Sep 20, 2013 at 10:59 AM, Chow Loong Jin wrote: > Just speaking for myself here, but I find that the binary format is more > flexible in that pg_restore can selectively restore things, generate DROP ____ > statements, restoring things in parallel and such. All in all, the binary > format > seems much more useful than the SQL format.
In this case we are talking about installation and upgrades, presumably selective restoration etc aren't needed here. > You can also compress the binary format (pg_dump -Z0..9), but it still isn't > as > efficient as SQL compressed with xz -9. It is more efficient than SQL but less efficient than even lzop -1, I guess there is not much compression. It is also impossible to patch the binary format unlike SQL. Anyway, this is getting off-topic. As long as the ftpteam are made aware of the format's properties everything should be fine. -- bye, pabs http://wiki.debian.org/PaulWise -- To UNSUBSCRIBE, email to debian-wnpp-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/caktje6hg9g0b3lzhc9gco2e5zawbc5uheapbaubss7lgnrt...@mail.gmail.com
