Commit924e1d0

committed

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.netDiscussion:https://postgr.es/m/162653459215.701.6323855956817776386@wrigleys.postgresql.orgBackpatch-through: 9.6

1 parentfb23408 commit924e1d0Copy full SHA for 924e1d0

File tree

+11

-2

lines changed

+11

-2

lines changed

Lines changed: 11 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -273,17 +273,26 @@ cat <replaceable class="parameter">filename</replaceable>.gz \| gunzip \| psql <re`
`273`	`273`	`The <command>split</command> command`
`274`	`274`	`allows you to split the output into smaller files that are`
`275`	`275`	`acceptable in size to the underlying file system. For example, to`
`276`		`- makechunks of 1 megabyte:`
	`276`	`+ make2 gigabyte chunks:`
`277`	`277`
`278`	`278`	`<programlisting>`
`279`		`-pg_dump <replaceable class="parameter">dbname</replaceable> \| split -b1m - <replaceable class="parameter">filename</replaceable>`
	`279`	`+pg_dump <replaceable class="parameter">dbname</replaceable> \| split -b2G - <replaceable class="parameter">filename</replaceable>`
`280`	`280`	`</programlisting>`
`281`	`281`
`282`	`282`	`Reload with:`
`283`	`283`
`284`	`284`	`<programlisting>`
`285`	`285`	`cat <replaceable class="parameter">filename</replaceable>* \| psql <replaceable class="parameter">dbname</replaceable>`
`286`	`286`	`</programlisting>`
	`287`	`+`
	`288`	`+ If using GNU <application>split</application>, it is possible to`
	`289`	`+ use it and <application>gzip</application> together:`
	`290`	`+`
	`291`	`+<programlisting>`
	`292`	`+pg_dump <replaceable class="parameter">dbname</replaceable> \| split -b 2G --filter='gzip > $FILE.gz'`
	`293`	`+</programlisting>`
	`294`	`+`
	`295`	`+ It can be restored using <command>zcat</command>.`
`287`	`296`	`</para>`
`288`	`297`	`</formalpara>`
`289`	`298`

Comments

(0)