How to backup and restore large Django data on PostgreSQL faster and more efficiently
3 min readJan 6, 2023
It can be really frustuating when using the Django loaddata command to backup and restore a large amount of data on Django which usually take a lot of time.
I needed to restore data from a PostgreSQL database containing about 75,000 rows of data and after hours of unsuccessful attempt due to django constraint errors, speed and so many other issues, I figured out there was no point trying to tweak the load data output file which was now almost 1GB in size. If you are facing a similar…