Re: Another pg_dump using split and gzip for large databases - Mailing list pgsql-docs

From James Doherty
Subject Re: Another pg_dump using split and gzip for large databases
Date
Msg-id CAMxig9oyn5xQzDp1q3_kbA9qUOqkADzn8KAWbBzL7e+HTjnTdw@mail.gmail.com
Whole thread Raw
In response to Re: Another pg_dump using split and gzip for large databases  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs
They key to my comment is splits —filter command which allows gzip each of the split files

On Wed, Jul 28, 2021 at 18:46 Bruce Momjian <bruce@momjian.us> wrote:
On Sat, Jul 17, 2021 at 03:09:52PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/backup-dump.html
> Description:
>
> 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.

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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

--
James M Doherty President Revive Consulting LLC

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Indexes on Expressions - a note to remind users to run ANALYZE after creation
Next
From: Bruce Momjian
Date:
Subject: Re: Logical error