Re: Another pg_dump using split and gzip for large databases
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 wrote: > On Sat, Jul 17, 2021 at 03:09:52PM +, 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 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
Re: Another pg_dump using split and gzip for large databases
Good point. On Thu, Jul 29, 2021 at 04:27 Daniel Gustafsson wrote: > > On 29 Jul 2021, at 01:46, Bruce Momjian wrote: > > On Sat, Jul 17, 2021 at 03:09:52PM +, 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
