Hot logical backups of all databases

If you have more than one database in your PostgreSQL server, you may want to take a logical backup of all the databases at the same time.

How to do it...

Our recommendation is that you do exactly what you did for one database to each database in your cluster.

You can run 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

How it works...

To back up all databases, you may be told you need to use the pg_dumpall utility. Following you can find four good reasons why you shouldn't do that:

• If you use pg_dumpall the only output produced will be in a script file. Script files can't benefit from all the features of archive files, such as parallel and selective restore of pg_restore. By making your backup in this way, you will immediately deprive yourself of flexibility and versatility at restore time.
• The pg_dumpall utility produces dumps of each database one after another...