On Thu, Jul 15, 2021 at 7:27 PM Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote: > It would probably complicate it, and dumping a whole cluster using > something like pg_dumpall -g for the globals plus a loop over the > databases using something like pg_dump -Fc ( which I would always > recommend over plain sql format ) is just a ( little complex ) one > liner or a 10 line script, probably not worth the scarce developer / > maintainer brain cycles. I always find the 502.pgsql FreeBSD backup script illuminating in this sense: <https://svnweb.freebsd.org/ports/head/databases/postgresql10-server/files/502.pgsql.in?view=markup#l44>. I used it as a base for my "loop and backup" scripts. Luca
