From: | Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_dumpall --exclude-database option |
Date: | 2018-08-03 19:13:42 |
Message-ID: | 43a54a47-4aa7-c70e-9ca6-648f436dd6e6@2ndQuadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
PFA a patch to provide an --exclude-database option for pg_dumpall. The
causes pg_dumpall to skip any database whose name matches the argument
pattern. The option can be used multiple times.
Among other use cases, this is useful where a database name is visible
but the database is not dumpable by the user. Examples of this occur in
some managed Postgres services.
I will add this to the September CF.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment | Content-Type | Size |
---|---|---|
pg_dumpall-exclude-database.patch | text/x-patch | 6.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-08-03 19:55:39 | Re: Standby trying "restore_command" before local WAL |
Previous Message | Tom Lane | 2018-08-03 17:55:04 | Re: pg_upgrade from 9.4 to 10.4 |