You can also follow this video guide to set up PostgreSQL
-
Download PostgreSQL and pg-admin4(optional).
-
Restore database from dump files
Before restoring data from dump file we need to create a database in which we could dump the data
createdb -h localhost -U postgres -W caucus_db
Dump Data to the database.
pg_restore --dbname caucus_db ./dump/caucus_db