If you have more than one database in your PostgreSQL server, you may want to back up all the databases together.
My recommendation is that you do exactly what you did for one database to each database in your cluster.
You can run those individual dumps in parallel if you want to speed things up.
Once this is complete, dump the global information also using the following:
To back up all databases, you may be told you need to use the
pg_dumpall utility. I have four reasons why you shouldn't do that, which are as follows:
pg_dumpall, then the only output produced is in a script file. Script files can't use the parallel restore feature of
pg_restore, so by taking your ...