Re: Another pg_dump using split and gzip for large databases

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
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 14:58:55
Message-ID: 20210729145855.GF9600@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thu, Jul 29, 2021 at 11:27:20AM +0200, Daniel Gustafsson wrote:
> > 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.

OK, I can adjust it to say "GNU split" or just skip this addition.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2021-07-29 15:14:17 Re: Common case not at all clear
Previous Message James Doherty 2021-07-29 10:48:28 Re: Another pg_dump using split and gzip for large databases