If you downloaded it from the public cloud then you have a backup file that was generated by postgres. To restore it you first need to run a postgres database locally and a pgadmin. You can find the downloads here
Wow ... that sounds a little bit more work than I was expecting. C'est la vie I guess. Thanks.
You can create a new database in Postgres. Right click on the new database you created and selected Restore, it will direct you to your file explorer, select the (database) ".backup" file you downloaded and click restore, it will start to restore your database.