Horton

Add support for --extension in pg_dump

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 6568cef26e0f40c25ae54b8e20aad8d1410a854b
Author: Michael Paquier <michael@paquier.xyz>
Date: 2021-03-31T00:12:34Z
Releases: 14.0 
Add support for --extension in pg_dump

When specified, only extensions matching the given pattern are included
in dumps.  Similarly to --table and --schema, when --strict-names is
used,  a perfect match is required.  Also, like the two other options,
this new option offers no guarantee that dependent objects have been
dumped, so a restore may fail on a clean database.

Tests are added in test_pg_dump/, checking after a set of positive and
negative cases, with or without an extension's contents added to the
dump generated.

Author: Guillaume Lelarge
Reviewed-by: David Fetter, Tom Lane, Michael Paquier, Asif Rehman,
Julien Rouhaud
Discussion: https://postgr.es/m/CAECtzeXOt4cnMU5+XMZzxBPJ_wu76pNy6HZKPRBL-j7yj1E4+g@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ref/pg_dump.sgml modified +38 −5
src/bin/pg_dump/pg_dump.c modified +87 −6
src/test/modules/test_pg_dump/t/001_base.pl modified +36 −17

Documentation touched

Discussion