diff options
| author | Bruce Momjian <bruce@momjian.us> | 2021-08-03 10:57:32 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2021-08-03 10:57:32 -0400 |
| commit | 924e1d0da958c82b79b225b43672532f9f36df9b (patch) | |
| tree | a0418d48fe2eef597f53f0ce98a5b69feb352db1 | |
| parent | fb234086fe81fb1848934b6e1f6382611fc9ad4f (diff) | |
| download | postgresql-924e1d0da958c82b79b225b43672532f9f36df9b.tar.gz postgresql-924e1d0da958c82b79b225b43672532f9f36df9b.zip | |
doc: add example of using pg_dump with GNU split and gzip
This is only possible with GNU split, not other versions like BSD split.
Reported-by: jim@jdoherty.net
Discussion: https://postgr.es/m/162653459215.701.6323855956817776386@wrigleys.postgresql.org
Backpatch-through: 9.6
| -rw-r--r-- | doc/src/sgml/backup.sgml | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 8c9186d277f..cba32b6eb3e 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -273,10 +273,10 @@ cat <replaceable class="parameter">filename</replaceable>.gz | gunzip | psql <re The <command>split</command> command allows you to split the output into smaller files that are acceptable in size to the underlying file system. For example, to - make chunks of 1 megabyte: + make 2 gigabyte chunks: <programlisting> -pg_dump <replaceable class="parameter">dbname</replaceable> | split -b 1m - <replaceable class="parameter">filename</replaceable> +pg_dump <replaceable class="parameter">dbname</replaceable> | split -b 2G - <replaceable class="parameter">filename</replaceable> </programlisting> Reload with: @@ -284,6 +284,15 @@ pg_dump <replaceable class="parameter">dbname</replaceable> | split -b 1m - <rep <programlisting> cat <replaceable class="parameter">filename</replaceable>* | psql <replaceable class="parameter">dbname</replaceable> </programlisting> + + If using GNU <application>split</application>, it is possible to + use it and <application>gzip</application> together: + +<programlisting> +pg_dump <replaceable class="parameter">dbname</replaceable> | split -b 2G --filter='gzip > $FILE.gz' +</programlisting> + + It can be restored using <command>zcat</command>. </para> </formalpara> |