Re: Another pg_dump using split and gzip for large databases

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: jim(at)jdoherty(dot)net, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Another pg_dump using split and gzip for large databases
Date: 2021-07-29 09:27:20
Message-ID: A38B4103-419D-46F7-9CCF-983DC826723D@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

> On 29 Jul 2021, at 01:46, Bruce Momjian <bruce(at)momjian(dot)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/

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message James Doherty 2021-07-29 10:48:28 Re: Another pg_dump using split and gzip for large databases
Previous Message David G. Johnston 2021-07-29 04:24:45 Re: Logical error