Let’s run through the restoration of the pgsql backup file supplied by GSWA and expedio for all those times when you just want to have some nice data to play with. Let’s first download the backup file from aws, change the path of the file mdhdb_data_and_structure.backup.gz to suit your setup. curl https://exp-gswa-mdhdb-bkt01.s3.ap-southeast-2.amazonaws.com/mdhdb_data_and_structure.backup.gz --output mdhdb_data_and_structure.backup.gz Of course you have already downloaded and installed postgres if not follow the process here to sort yourself out if you are trying this on windows…(hahaha) you will need to install sed and something to unzip.