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

Re: packaging Postgres binary dump files

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.



Reply to: