diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2019-03-01 10:47:44 -0500 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2019-03-01 10:47:44 -0500 |
| commit | f092de0503cd77a8463e7089c249d5e0586a120b (patch) | |
| tree | 062e2d672bb7db110393756d779116e6bdcc9dbf /doc/src | |
| parent | 9c32e4c35026bd52aaf340bfe7594abc653e42f0 (diff) | |
| download | postgresql-f092de0503cd77a8463e7089c249d5e0586a120b.tar.gz postgresql-f092de0503cd77a8463e7089c249d5e0586a120b.zip | |
Add --exclude-database option to pg_dumpall
This option functions similarly to pg_dump's --exclude-table option, but
for database names. The option can be given once, and the argument can
be a pattern including wildcard characters.
Author: Andrew Dunstan.
Reviewd-by: Fabien Coelho and Michael Paquier
Discussion: https://postgr.es/m/43a54a47-4aa7-c70e-9ca6-648f436dd6e6@2ndQuadrant.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dumpall.sgml | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index b3372a641f0..e3676cf811f 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -311,6 +311,27 @@ PostgreSQL documentation </listitem> </varlistentry> + + <varlistentry> + <term><option>--exclude-database=<replaceable class="parameter">pattern</replaceable></option></term> + <listitem> + <para> + Do not dump databases whose name matches + <replaceable class="parameter">pattern</replaceable>. + Multiple patterns can be excluded by writing multiple + <option>--exclude-database</option> switches. The + <replaceable class="parameter">pattern</replaceable> parameter is + interpreted as a pattern according to the same rules used by + <application>psql</application>'s <literal>\d</literal> + commands (see <xref + linkend="app-psql-patterns" endterm="app-psql-patterns-title"/>), + so multiple databases can also be excluded by writing wildcard + characters in the pattern. When using wildcards, be careful to + quote the pattern if needed to prevent shell wildcard expansion. + </para> + </listitem> + </varlistentry> + <varlistentry> <term><option>--if-exists</option></term> <listitem> |