From: Bruce Momjian <bruce@momjian.us>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: jim@jdoherty.net
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Another pg_dump using split and gzip for large databases
Date: Thu, 29 Jul 2021 10:58:55 -0400
Message-ID: <20210729145855.GF9600@momjian.us> (raw)
In-Reply-To: <A38B4103-419D-46F7-9CCF-983DC826723D@yesql.se>
References: <162653459215.701.6323855956817776386@wrigleys.postgresql.org>
<20210728234605.GA9600@momjian.us>
<A38B4103-419D-46F7-9CCF-983DC826723D@yesql.se>
On Thu, Jul 29, 2021 at 11:27:20AM +0200, Daniel Gustafsson wrote:
> > 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.
OK, I can adjust it to say "GNU split" or just skip this addition.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, daniel@yesql.se, jim@jdoherty.net, pgsql-docs@lists.postgresql.org
Subject: Re: Another pg_dump using split and gzip for large databases
In-Reply-To: <20210729145855.GF9600@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox