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:
pg_dumpall -g
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:
If you use
pg_dumpall
, then the only output produced is in a script file. Script files can't use the parallel restore feature ofpg_restore
, so by taking your backup in this way, you will be forcing the restore to be slower than it needs to be.The
pg_dumpall
utility produces dumps of each database one after another. This means thatpg_dumpall
is slower than running multiplepg_dump
tasks in parallel,...