Postgres Pro
Downloads
Home   >   mailing lists

Re: Another pg_dump using split and gzip for large databases - Mailing list pgsql-docs

From Daniel Gustafsson
Subject Re: Another pg_dump using split and gzip for large databases
Date
Msg-id A38B4103-419D-46F7-9CCF-983DC826723D@yesql.se
Whole thread Raw
In response to Re: Another pg_dump using split and gzip for large databases  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Another pg_dump using split and gzip for large databases  (Bruce Momjian <bruce@momjian.us>)
Re: Another pg_dump using split and gzip for large databases  (James Doherty <jim@jdoherty.net>)
List pgsql-docs
Tree view 
> On 29 Jul 2021, at 01:46, Bruce Momjian <bruce@momjian.us> wrote:
> On Sat, Jul 17, 2021 at 03:09:52PM +0000, PG Doc comments form wrote:

>> pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz'
>
> Wow, odd we didn't have an example of using gzip and split together;
> patch attached.

Maybe because the --filter option is only available in GNU split and not in
POSIX, and thus not on FreeBSD and macOS etc.  I'm not sure about what level of
compatibility we strive for in the examples though.

--
Daniel Gustafsson        https://vmware.com/

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Logical error
Next
From: James Doherty
Date:
Subject: Re: Another pg_dump using split and gzip for large databases