| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> | 
|---|---|
| To: | Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> | 
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Re: pg_dumpall --exclude-database option | 
| Date: | 2018-08-03 21:08:57 | 
| Message-ID: | alpine.DEB.2.21.1808032239420.30462@lancre | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
> 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.
This looks like a reasonable feature.
> I will add this to the September CF.
My 0.02€:
Patch applies cleanly, compiles, and works for me.
A question: would it makes sense to have a symmetrical 
--include-database=PATTERN option as well?
Somehow the option does not make much sense when under -g/-r/-t... maybe 
it should complain, like it does when the others are used together?
ISTM that it would have been better to issue just one query with an OR 
list, but that would require to extend "processSQLNamePattern" a little 
bit. Not sure whether it is worth it.
Function "database_excluded": I'd suggest to consider reusing the
"simple_string_list_member" function instead of reimplementing it in a 
special case.
XML doc: "--exclude-database=dbname", ISTM that 
"--exclude-database=pattern" would be closer to what it is? "Multiple 
database can be matched by writing multiple switches". Sure, but it can 
also be done with a pattern. The documentation seems to assume that the 
argument is one database name, and then changes this afterwards. I'd 
suggest to start by saying that a pattern like psql is expected, and then 
proceed to simply tell that the option can be repeated, instead of 
implying that it is a dbname and then telling that it is a pattern.
The simple list is not freed. Ok, it seems to be part of the design of the 
data structure.
-- 
Fabien.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Jelinek | 2018-08-03 21:20:13 | Re: patch to allow disable of WAL recycling | 
| Previous Message | Andrew Gierth | 2018-08-03 21:08:04 | Re: Should contrib modules install .h files? |