Re: [HACKERS] pg_basebackup: Allow use of arbitrary compression program - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: [HACKERS] pg_basebackup: Allow use of arbitrary compression program
Date
Msg-id CAMkU=1wp3ftSiwkq8Q7y-c03DWc82ZrjPQsVgQ_8TaMg7BeF6g@mail.gmail.com
Whole thread Raw
In response to [HACKERS] pg_basebackup: Allow use of arbitrary compression program  (Michael Harris <harmic@gmail.com>)
List pgsql-hackers
On Thu, Apr 6, 2017 at 7:04 PM, Michael Harris <harmic@gmail.com> wrote:
Hello,

Back in pg 9.2, we hacked a copy of pg_basebackup to add a command
line option which would allow the user to specify an arbitrary
external program (potentially including arguments) to be used to
compress the tar backup.

Our motivation was to be able to use pigz (parallel gzip
implementation) to speed up the compression. It also allows using
tools like bzip2, xz, etc instead of the inbuilt zlib.

I never ended up submitting that upstream, but now it looks like I
will have to repeat the exercise for 9.6, so I was wondering if such a
feature would be welcomed.

I would welcome it.  I would really like to be able to use parallel pigz and pxz.

You can stream the data into a compression tool of your choice as long as you use tar mode and specify '-D -', but that is incompatible with table spaces, and with xlog streaming, and so is not a very good solution.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Yorick Peterse
Date:
Subject: Re: [HACKERS] [PATCH] Document the order of changing certain settingswhen using hot-standby servers
Next
From: Heikki Linnakangas
Date:
Subject: Re: [HACKERS] Duplicate assignment in Unicode/convutils.pm