should pg_dumpall --clean apply to database in --exclude-database - Mailing list pgsql-hackers

From jian he
Subject should pg_dumpall --clean apply to database in --exclude-database
Date
Msg-id CACJufxH8tDcuj+UP3qzNV-vYOtQL4-pUQDMF6cEMvstRfSHMPg@mail.gmail.com
Whole thread
Responses Re: should pg_dumpall --clean apply to database in --exclude-database
List pgsql-hackers
Hi.

https://www.postgresql.org/docs/devel/app-pg-dumpall.html
--clean options says
"""
Emit SQL commands to DROP all the dumped databases, roles, and
tablespaces before recreating them.
"""

Currently, with --clean, pg_dumpall still emits a DROP DATABASE
command for databases excluded with --exclude-database.
It is not clear to me whether --clean is meant to apply to excluded databases.

Let's see how --clean and --exclude-table work.
If I say
--clean --exclude-table=onek2
then no SQL command ``DROP TABLE public.onek2``.



--
jian
https://www.enterprisedb.com/



pgsql-hackers by date:

Previous
From: JoongHyuk Shin
Date:
Subject: Re: [PATCH] Extend MXactCache lifetime from per-transaction to per-session
Next
From: "ZizhuanLiu X-MAN"
Date:
Subject: Re: Optimize MCV stats for sortable types and utilize sorted-order properties