Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m97Uz-0000Sp-QN for pgsql-docs@arkaria.postgresql.org; Thu, 29 Jul 2021 14:59:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m97Ux-0001JY-Qx for pgsql-docs@arkaria.postgresql.org; Thu, 29 Jul 2021 14:58:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m97Ux-0001JQ-Kv for pgsql-docs@lists.postgresql.org; Thu, 29 Jul 2021 14:58:59 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m97Uv-0001ne-GT for pgsql-docs@lists.postgresql.org; Thu, 29 Jul 2021 14:58:58 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1m97Ut-0002Go-O6; Thu, 29 Jul 2021 10:58:55 -0400 Date: Thu, 29 Jul 2021 10:58:55 -0400 From: Bruce Momjian To: Daniel Gustafsson Cc: jim@jdoherty.net, pgsql-docs@lists.postgresql.org Subject: Re: Another pg_dump using split and gzip for large databases Message-ID: <20210729145855.GF9600@momjian.us> References: <162653459215.701.6323855956817776386@wrigleys.postgresql.org> <20210728234605.GA9600@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 29, 2021 at 11:27:20AM +0200, Daniel Gustafsson wrote: > > On 29 Jul 2021, at 01:46, Bruce Momjian 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 https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.