Comment by maskros

Or use "VACUUM INTO" to get a backup that is is even faster (and easier) to restore.