Re: Another pg_dump using split and gzip for large databases

From: James Doherty <jim(at)jdoherty(dot)net>
To: daniel(at)yesql(dot)se
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Another pg_dump using split and gzip for large databases
Date: 2021-07-29 10:48:28
Message-ID: CAMxig9re6uk0_P6wCAo2PTpeLHJ-n_B9So-hEt1AWGEdjQ5d7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Good point.

On Thu, Jul 29, 2021 at 04:27 Daniel Gustafsson <daniel(at)yesql(dot)se> 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.
>
> --
> Daniel Gustafsson https://vmware.com/
>
> --
James M Doherty President Revive Consulting LLC

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2021-07-29 14:58:55 Re: Another pg_dump using split and gzip for large databases
Previous Message Daniel Gustafsson 2021-07-29 09:27:20 Re: Another pg_dump using split and gzip for large databases