pg_dumpall --exclude-database option

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
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

Responses

Browse pgsql-hackers by date

  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