postgres: additional option -cC breaks global dumpall

[joergmschulz]

Summary

if I use the - DEFAULT_EXTRA_OPTS=-cC for postgres (which adds the dump and create commands for the saved databases), the saving of the global options pg_dumpall will not work.

 [01-postgres-db__ALL] Dumping PostgresSQL globals: with 'pg_dumpall -g' 
pg_dumpall: unrecognized option: C
pg_dumpall: hint: Try "pg_dumpall --help" for more information.
2024-01-06.22:08:13 [NOTICE] ** [01-postgres-db__ALL] Generating MD5 sum for 'pgsql_globals_postgres-db_20240106-220813.sql'
2024-01-06.22:08:13 [NOTICE] ** [01-postgres-db__ALL] Backup of 'pgsql_globals_postgres-db_20240106-220813.sql' created with the size of 0 bytes
2024-01-06.22:08:13 [NOTICE] ** [01-postgres-db__ALL] Sending Backup Statistics to Zabbix
Response from "zabbix-server:10051": "processed: 1; failed: 0; total: 1; seconds spent: 0.000150"
sent: 1; skipped: 0; total: 1

Steps to reproduce

add - DEFAULT_EXTRA_OPTS=-cC

What is the expected correct behavior?

there should be separate options for pg_dump and pg_dumpall for postgres. Or, just another option to include the dump/create commands, they could be interesting for mariadb and others as well.

additionally, you see the exit code of pg_dumpall isn't processed; the processed:1, failed: 0 isn't what happened....